Hi, Im writing a script for site search, how do you do a mysql querry for a word like members.
mysql_querry("select from search searchword WHERE search word ????????????? ");
Thanx for your help!
-Jason Rottman
the first thing you need to do is spell query correctly.
:-)
you use the LIKE keyword. Note that wildcards are percent signs % not asterisks. viz
SELECT * FROM tbl_foo WHERE searchword LIKE '%members%'
will return every instance with "members" buried somewhere in searchword.
