views:

15

answers:

1

To do text search for wordA, wordB and wordC right now I'm doing it this way:

SELECT * FROM 
    mytable 
WHERE
    MATCH (field1) AGAINTS ('wordA' IN BOOLEAN MODE) OR
    MATCH (field1) AGAINTS ('wordB' IN BOOLEAN MODE) OR
    MATCH (field1) AGAINTS ('wordC' IN BOOLEAN MODE)

Is there a more compact way of writing this?

A: 

Just worked out this will work too

SELECT * FROM 
    mytable 
WHERE
    MATCH (field1) AGAINTS ('wordA/wordB/wordC' IN BOOLEAN MODE)
Am
that's pretty neat.
DMin