Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How does MySQL fulltext search work?

I have a pretty good idea how to implement fulltext search with MySQL. I know how to add indexes and make a query and sort my results.

But I have been trying to get some more in-dept information on how it works, so to say what happens behind the scenes. How does MySQL determine the results relevance. What does the score even mean? Which can reach from 0.1 to over 4.6 (which I have seen at least, probably more) And what is really being indexed?

What happens to my search string that is entered?

I am thankful for links or explanations here!

like image 899
jamietelin Avatar asked Mar 22 '12 10:03

jamietelin


1 Answers

This page has a good explanation - http://dev.mysql.com/doc/internals/en/full-text-search.html

like image 104
nnichols Avatar answered Oct 24 '22 11:10

nnichols