MySQL全文关键字顺序？

Question

我现在正在做一个小搜索算法，我想知道MySQL全文搜索权重关键字是否按出现顺序排列？

例如:

Search Term: php macaroni pizza custard

在全文搜索中，PHP 是否比 custard 更“相关”？还是两者相等？

Answer 1

mySQL manual ，如果我没看错的话，说没有区别:

the rows returned are automatically sorted with the highest relevance first. Relevance values are nonnegative floating-point numbers. Zero relevance means no similarity. Relevance is computed based on the number of words in the row, the number of unique words in that row, the total number of words in the collection, and the number of documents (rows) that contain a particular word.

-

Every correct word in the collection and in the query is weighted according to its significance in the collection or query. Consequently, a word that is present in many documents has a lower weight (and may even have a zero weight), because it has lower semantic value in this particular collection. Conversely, if the word is rare, it receives a higher weight. The weights of the words are combined to compute the relevance of the row.