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?