#1191-找不到与列列表匹配的FULLTEXT索引 [英] #1191 - Can't find FULLTEXT index matching the column list

问题描述

我正在尝试在我的xampp中执行此查询，但是它没有出现.

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);

尝试上述查询将全文索引添加到列中.

Try the above query to add full text index to the columns.

这篇关于#1191-找不到与列列表匹配的FULLTEXT索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！