Mega Code Archive

 

Categories / MySQL / Fulltext Search

 

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;