I suppose having the phrase "Galvaccino Moccaee", this data I can keyword search for "vac mocc". where the word "vac" exists between the word I was looking at the data, then the word "mocc" are on the second word in my data.
Such a search is broken because if we forget the name of the data or only remembera few letters only.
I have a php code for a search as I described above. This code is quite simple:
Just change your table name and field name.
@$hasil.="LOWER($namaField) LIKE '%$Kata%' OR ";
$SQL.=" WHERE $hasil";
$result=mysql_query("select * from menu where menu_name like '%$Kata%'");}
I hope this article helpful. use the code to your search to be more dynamic