Facing problem at codeigniter multiple word search
You can replace this
$this->db->like('book_name', $query);
with condition as
$str = str_replace(" ","|", $query);$this->db->where("book_name rlike '$str'");
You can get more details about rlike here.
Here is a better full text search help provided for your reference.