Mr.Boon Mr.Boon - 3 months ago 19
MySQL Question

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?

Answer

You need a third index:

FULLTEXT(item_title, item_description)
Comments