How Mysql full text search relevances compute?

Question

How does MySQL compute the relevance of results of a full-text search? I know as it's documented:

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.

But how these parameters come into those numbers?

sounds like this SO question : http://stackoverflow.com/questions/237970/full-text-search-relevance-is-measured-in — Kevin Burton, Aug 24 '11 at 13:55

score 0 · Accepted Answer · answered Aug 24 '11 at 16:33

0

Here there's the explain of the full-text algorithm http://forge.mysql.com/wiki/MySQL_Internals_Algorithms#Full-text_Search

answered Aug 24 '11 at 16:33

Fabio Cicerchia

649
3
8
23

so it seams so complicated! I thought it has a simple answer! – Kamran Aug 24 '11 at 17:21

How Mysql full text search relevances compute?

1 Answers1