mysql - SQL:其中 Field OR Field2 LIKE %entry%

Question

是否有更简单/更有效的方法来执行以下 WHERE 条件:

WHERE (Field LIKE %entry% OR Field2 LIKE %entry%)
AND (Field LIKE %entry2% OR Field2 LIKE %entry2%)

Answer 1

请引用以下link还有:

SELECT  *
FROM    mytable
WHERE   MATCH(filed, field2) AGAINST ('entry' IN NATURAL LANGUAGE MODE)