On 31 Jan 2009, at 01:50, Bob Sneidar wrote:
Never mind I figured it out. You have to use MATCH() AGAINST() with
MyISAM tables and the columns you search have to have fulltext
indexes created for them. Works like a charm though.
SELECT * FROM myISAMTable MATCH (deptid) AGAINST ('ACCT,FROF,DEV')
returns records whose deptid is in 'ACCT,FROF,DEV'
I think the more general syntax would be to use "IN"
SELECT * FROM myISAMTable
WHERE deptid IN ('ACCT','FROF','DEV')
Cheers
Dave
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
