RE: [PHP] Keyword Search

[snip] I've inherited a database so must live with a less than elegant structure. The table contains one "keyword" field into which the author has entered things like... Record 1 = Apples Record 2 = Apples, Bananas Record 3 = Apples, Figs Record 4 = Bananas, Figs, Dates I need to do a search on this field to return all of the records containing "Figs". What's the search syntax? I've tried... SELECT * from dbname.tablename MATCH (dbname.fieldname) AGAINST 'Figs' [/snip] A. Belongs on a SQL list (and there are plenty) 2. SELECT * FROM dbname.tablename WHERE (dbname.fieldname) LIKE '%Figs%'