Fulltext Search MySQL

  1. Home
  2. MySQL
  3. Fulltext Search
  4. A MATCH expression for fulltext search can be used to order results
-- The following query returns the five best results.
SELECT *,
MATCH(column1, column2) AGAINST('word1 word2 word3') AS mtch
FROM tablename
HAVING mtch > 0.001
ORDER BY mtch DESC
LIMIT 5;