Another SQL question

Dave Cragg 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')

Cheers
Dave



More information about the Use-livecode mailing list