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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to