Innodb:查询多于1列时找不到与列列表匹配的FULLTEXT索引(Innodb: Can't find FULLTEXT index matching the column list when queried more than 1 columns)

19 IT屋

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?

解决方案

You need a third index:

FULLTEXT(item_title, item_description)

我正在尝试在MySQL INNODB表上运行一个非常简单的查询:



  SELECT * 
FROM项目
匹配项(item_title,item_description)反对('dog')


两个列< code> item_title 和 item_description 具有 FULLTEXT 索引。



我一直收到此错误:




找不到与列列表匹配的FULLTEXT索引< / p>



我的问题:当我查询 just item_title时或 just item_description 即可正常工作。但是,当我一次在一次查询中同时执行两个操作时,如上所示,我得到了该错误。 div class =" h2_lin">解决方案

您需要第三个索引:



  FULLTEXT(item_title, item_description)

本文地址:IT屋 » Innodb:查询多于1列时找不到与列列表匹配的FULLTEXT索引