sql Match（）反对无法识别(sql Match () Against unrecognized)

sql Match（）反对无法识别(sql Match () Against unrecognized)

当我尝试这个查询

SELECT name, cost FROM items WHERE MATCH (name) AGAINST ('baby')

phpmyadmin给了我一个警告：

Unrecognized keyword. (near "MATCH" at position 43) Unexpected token. (near "(" at position 49) Unexpected token. (near "name" at position 50) Unexpected token. (near ")" at position 58) Unrecognized keyword. (near "AGAINST" at position 60) Unexpected token. (near "(" at position 68) Unexpected token. (near "'baby'" at position 69) Unexpected token. (near ")" at position 74)

它仍然显示正确的结果。 当我尝试另一个查询：

SELECT fisrt_name , country FROM people WHERE MATCH (first_name) AGAINST ('marr')

它只给我和错误而没有得到结果。 我做错了吗？

编辑：我更新了phpmyadmin，但我得到的是新的错误消息说

Can't find FULLTEXT index matching the column list

When I tried this query

SELECT name, cost FROM items WHERE MATCH (name) AGAINST ('baby')

phpmyadmin gives me a warning that states:

Unrecognized keyword. (near "MATCH" at position 43) Unexpected token. (near "(" at position 49) Unexpected token. (near "name" at position 50) Unexpected token. (near ")" at position 58) Unrecognized keyword. (near "AGAINST" at position 60) Unexpected token. (near "(" at position 68) Unexpected token. (near "'baby'" at position 69) Unexpected token. (near ")" at position 74)

and it still shows the correct result. When I tried another query:

SELECT fisrt_name , country FROM people WHERE MATCH (first_name) AGAINST ('marr')

It only gives me and error without getting result. Is there any mistakes that I did?

EDIT: I updated the phpmyadmin but what I got is new error message saying

Can't find FULLTEXT index matching the column list

最满意答案

ALTER TABLE people ADD FULLTEXT people_first_name(first_name);

尝试此操作在列first_name上添加全文索引，然后重试查询。

ALTER TABLE people ADD FULLTEXT people_first_name(first_name);

Try this to add a full text index on column first_name, and retry your query.