Search code examples
mysqlfull-text-searchinnodb

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?

Solution

  • You need a third index:

    FULLTEXT(item_title, item_description)