如何在MySQL中使用Match [英] How to use match against in mysql

问题描述

TABLE ITEMS: (id, name)
1| chicken
2| potato

查询:

select * from items where match(name) against('tato');

正在返回一个空集.我想念过如何与比赛相提并论吗?

An empty set is being returned. Have I miss understood how match against works ?

推荐答案

我不认为FULLTEXT索引支持部分单词匹配.对于这样的事情，最好使用Marco描述的一种构造.

I don't think FULLTEXT indices support partial word matches. For something like this you're better off using one of the constructions described by Marco.

这篇关于如何在MySQL中使用Match的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！