Re: Keyword Search

Hello Robb, Tuesday, April 6, 2004, 5:24:55 PM, you wrote: RK> I need to do a search on this field to return all of the records containing RK> "Figs". What's the search syntax? RK> I've tried... RK> SELECT * from dbname.tablename MATCH (dbname.fieldname) AGAINST 'Figs' RK> It doesnt' work. Does the keywords table have a fulltext index on it? If so the above would work, but only if you have reduced the minimum word length allowed. You could just do: SELECT * FROM table WHERE keyword LIKE '%Figs%' ? -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html