FULLTEXT

FULLTEXT搜索短的查询语句无效解决方案

六 3rd

由Aiice发表在MySQL

例如：

mysql> SELECT COUNT(*) FROM kjv WHERE MATCH(vtext) AGAINST('God');
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+
mysql> SELECT COUNT(*) FROM kjv WHERE MATCH(vtext) AGAINST('sin');
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+

搜索引擎会忽略那些太常见的短语句如 the and 之类的单词都是索引不到的不信邪那验证下：

mysql> SELECT COUNT(*) AS 'total verses',
    -> COUNT(IF(vtext LIKE '%God%',1,NULL)) AS 更多 >

FULLTEXT