Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Innodb: Can't find FULLTEXT index matching the column list when queried more than 1 columns

I'm trying to run a very simple query on my MySQL INNODB table:

SELECT * 
FROM items 
WHERE MATCH (item_title,item_description) AGAINST ('dog')

Both column item_title and item_description have a FULLTEXT index.

I keep getting this error:

Can't find FULLTEXT index matching the column list

My issue: when I query just item_title or just item_description then it works fine. But when I do both at once in 1 query, as shown above, I get that error.

Any idea what is wrong?

like image 204
Mr.Boon Avatar asked Aug 25 '15 09:08

Mr.Boon


1 Answers

You need a third index:

FULLTEXT(item_title, item_description)
like image 56
Rick James Avatar answered Oct 04 '22 14:10

Rick James