MySQL Fulltext Search Score Explained

by

Take the query “word1 word2” as an example.

BOOLEAN mode indicates that your entire query matches the document (e.g. it contains both word1 AND word2). Boolean mode is a strict match.

The formula normally used is based on the Vector Space Model of searching. Very simplified, it figures out two measures to determine how important a word is to a query. The term frequency (terms that occur often in a document are more important than other terms) and the inverse document frequency (a term that occurs in many documents is weighted lower than a term that occurs in few documents). This is known as tf-idf, and is used as a basis for the vector space model. These scores form the basis for the Vector Space Model, which someone else can explain thoroughly. 🙂

More Related Contents:

  1. Comparison of full text search engine – Lucene, Sphinx, Postgresql, MySQL? [closed]
  2. Search for “whole word match” in MySQL
  3. Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]
  4. MySQL match() against() – order by relevance and column?
  5. mysql fulltext search failure
  6. How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
  7. Django MySQL full text search
  8. How to allow fulltext searching with hyphens in the search query
  9. Delete the entire content of all table in a Database [closed]
  10. MyISAM versus InnoDB [closed]
  11. MySQL string replace
  12. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  13. How do I find the MySQL my.cnf location
  14. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  15. MySQL select one column DISTINCT, with corresponding other columns
  16. How to use mysql JOIN without ON condition?
  17. How to remove all non-alpha numeric characters from a string in MySQL?
  18. Define a variable within select and use it within the same select
  19. ERROR: Error 1005: Can’t create table (errno: 121)
  20. Mysql Convert Column to row (Pivot table )
  21. Merge two tables in one SQL query and make the date values unique
  22. mySQL subquery limit
  23. Greatest value of multiple columns with column name?
  24. libmysqlclient15-dev on macs?
  25. I keep getting this mysql error code #1089
  26. How to close sqlalchemy connection in MySQL
  27. How do I lock on an InnoDB row that doesn’t exist yet?
  28. How can I achieve initcap functionality in MySQL?
  29. Mysql stored procedure don’t take table name as parameter
  30. Composite Primary Key performance drawback in MySQL

Leave a Comment