Re: Keyword Search

On Tue, 6 Apr 2004 11:25:09 -0500, Jay Blanchard wrote: > [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%' Thanx for the advice. I'll give it a try. BTW, I know that some of my questions belong on a SQL list. Can you recommend any? I haven't found any as active or helpful as this PHP one. -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org