无法在我的表上分配FULLTEXT索引 [英] Can't assign FULLTEXT index on my table

问题描述

我正在尝试使用查询扩展在数据库表上实现搜索功能，并且我知道我必须在要变得可搜索的字段上添加FULLTEXT索引.我尝试执行此操作，但从PHPMyAdmin中未收到任何错误，但是当我检查表的结构时，FULLTEXT索引的基数为0.我尝试单独设置FULLTEXT索引，但它似乎可以工作，但是我的Serach返回了错误: 找不到与列列表匹配的FULLTEXT索引

I am trying to implement a search function on a database table using query expansion, and I'm aware that I have to add the FULLTEXT index on the fields I want to become searchable. I have tried to do this and got no errors from PHPMyAdmin, but when I examine the structure of the table the cardinality of the FULLTEXT index is 0. I have tried inidividually setting the FULLTEXT index and it seems to work, but my serach returns the error: Can't find FULLTEXT index matching the column list

任何想法出了什么问题?

Any ideas what's going wrong?

推荐答案

我必须在我希望可搜索的所有字段上添加索引，并组合起来想要搜索它们...

I had to add the index on all fields i wanted to be searchable and in the combination I wanted to search them...

这篇关于无法在我的表上分配FULLTEXT索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！