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

Question

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

Answer 1

ALTER TABLE table ADD FULLTEXT index_name(column1);

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