mysql - 有趣的 MATCH AGAINST 问题 : not searching some words

Question

我有一个这样的表:

|====brand=====|======title================|
|....Apple.....|...iPhone 5 32 GB..........|
|....Sony......|...Bluetooth Headset.......|

我使用全文搜索基本上是这样的:

SELECT
  *,
  MATCH(brand,title) AGAINST ('some words') as score
FROM
  table

所以当我搜索耳机时，mysql 给出了 1.812121 的真实分数。

但是当我搜索 iphone 时； mysql 给 0 分。

P.s: ft_min_word_len = 2

Answer 1

来自 http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

A natural language search interprets the search string as a phrase in natural human language (a phrase in free text). There are no special operators. The stopword list applies. In addition, words that are present in 50% or more of the rows are considered common and do not match. Full-text searches are natural language searches if no modifier is given.

所以关于常用词的部分听起来很可能。