i have implemented an ajax search suggest system into my application and initially the PHP that was being called by ajax said something along the lines of:
$query = mysql_query("SELECT item FROM table WHERE item like('%" . $search . "%') ORDER BY item");
Now that works fine for a small database, but if the db gets large, this is a poor method of searching for strings within your db…so i implemented full-text search.
the problem is that now, however, when you search for a word, the ajax suggest only kicks in AFTER you have completed the whole word, not just letter by letter (since its looking for the whole word rather than the % $search % idea.
anyone know how to get around this without sacrificing db & script performance?
