mysql - 简化mysql全文搜索

Question

现在要对 wordA、wordB 和 wordC 进行文本搜索，我是这样做的:

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

有没有更简洁的写法？

Answer 1

刚想出来这也行

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