#1191 - 找不到与列列表匹配的 FULLTEXT 索引

Iam trying to execute this query in my xampp, but it is not turning up.

SELECT pid,description,alttext FROM wp_ngg_pictures WHERE MATCH 
(description, filename, alttext) AGAINST ('*image2*' IN BOOLEAN MODE) AND exclude != 1

它返回了这个错误

 #1191 - Can't find FULLTEXT index matching the column list.

谁能帮帮我

推荐答案

ALTER TABLE table ADD FULLTEXT index_name(column1);

尝试上面的查询来为列添加全文索引.