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')
item_description have a
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?
You need a third index:
Answered By – Rick James
Answer Checked By – Timothy Miller (BugsFixing Admin)