Another SQL question
dave.cragg at lacscentre.co.uk
Sat Jan 31 03:30:39 EST 2009
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')
More information about the Use-livecode