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

Issue

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?

Solution

You need a third index:

FULLTEXT(item_title, item_description)

Answered By – Rick James

Answer Checked By – Timothy Miller (BugsFixing Admin)