# 1191 - Cannot find the FULLTEXT index matching the column list

I am trying to execute this request in my xampp but it does not open.

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

he returned this error

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

can someone help me? plz

+2
source share
1 answer
ALTER TABLE table ADD FULLTEXT index_name(column1);

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

+6
source

Source: https://habr.com/ru/post/1628962/


All Articles