Re: problem with searching mysql in php

2003-07-24 Thread John Hicks
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

problem with searching mysql in php

2003-07-24 Thread 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