找不到与列列表匹配的 FULLTEXT 索引(已设置索引) [英] Can't find FULLTEXT index matching the column list (indexes is set)
问题描述
我正在处理全文,我执行了一个命令将全文索引添加到多个评论中,并且没有返回任何错误,然后我做到了:
I'm working with fulltext, I executed an command to add the fulltext index to multiple comments, and returned no errors, then I did:
SELECT * FROM products WHERE MATCH(`brand`) AGAINST('Skoda');
品牌栏中的内容 - 但我得到以下信息:
Which is in the brand column - but I get following:
找不到与列列表匹配的 FULLTEXT 索引
Can't find FULLTEXT index matching the column list
Eventho,当我的桌子看起来像这样时:
Eventho, when my table looks like this:
FULLTEXT KEY `name` (`name`,`breadcrumb`,`description`,`brand`,`price`,`year`,`km`,`usage`,`type`)
是不是因为我应该使用 name
代替?做搜索?或者有什么问题.
Is it because I should use the name
instead? to do the search? Or what can be wrong.
推荐答案
假设您使用的是 MyISAM 引擎,请执行:
Assuming you are using MyISAM engine, Execute:
ALTER TABLE products ADD FULLTEXT(brand);
全文索引应包含与 MATCH 子句中提到的相同顺序的完全相同数量的列.
The fulltext index should contain exactly the same number of columns, in same order as mentioned in MATCH clause.
这篇关于找不到与列列表匹配的 FULLTEXT 索引(已设置索引)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!