Looks like you really want to be doing full-text searching:
http://www.mysql.com/doc/en/Fulltext_Search.html
As you are doing it now, your users will only get a hit if
they enter the target keywords in the same sequence they
are stored in.
--John
On Wednesday 23 July 2003 04:24 am, Ercan Yurt
Hi All,
Im writing a quick search in php. in this search user can enter turkish,english and
greek key words and i search them in mysql table(MyIsam), in this table data are in
unicode
my sql string like that
SELECT MAddInfo.idUL,MAddInfo.sBrief FROM MAddInfo LEFT JOIN UL ON
MAddInfo.idUL