KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I've been experimenting with fulltext search lately and am curious about the meaning of the Score value. For example I have the following query: SELECT table. * , MATCH ( col1, col2, col3 ) AGAINST ( '+(Term1) +(Term1)' ) AS Score FROM table WHERE MATCH ( col1, col2, col3 ) AGAINST ( '+(Term1) +(Term1)' ) In the results for Score I've seen results, for one query, between 0.4667041301727 to 11.166275978088. I get that it's MySQLs idea of relevance (the higher the more weight). What I don't get is how MySQL comes up with that score. Why is the number not returned as a decimal or something besides ? How come if I run a query "IN BOOLEAN MODE" does the score always return a 1 or a 0 ? Wouldn't all the results be a 1? Just hoping for some enlightenment. Thanks.
Tags (comma-separated)
Save Edits
Cancel