Is possible multiple words search in codeigniter?
===

Its first time I am willing to add multiple search. I am not sure it should be done. Should I use loop each word in search? or is there any mysql built in function there for it?


What I am thinking it should be like that?


     $strSearch = $this->input->post("search"); // would hold words etc hello word

     $arry = explode(" ", $strSearch);

     foreach($arry as $item){

     $this->db->query("select * from tbl where item like '%$item%');

    }


Please advice.

Thank You