mysql - CONTAINS 在 mysql 中不工作

Question

我正在使用 CONTAINS，但它在 mysql 中不起作用。

 mysql> SELECT * FROM MUTHU;
+---------------------+
| MY                  |
+---------------------+
| how is your studies |
| how are you there   |
| hi there            |
+---------------------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM MUTHU CONTAINS ( MY, "how" );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '( MY,
 "how" )' at line 1

Answer 1

我认为 MYSQL 没有名为 CONTAINS 的函数，请尝试以下查询:

SELECT * FROM MUTHU
WHERE MY LIKE '%how%';