Fulltext Search MySQL

  1. Home
  2. MySQL
  3. Fulltext Search
  4. Full-Text Search syntax
For a full-text search, the SQL expression MATCH AGAINST is used:
SELECT * FROM tablename
WHERE MATCH(column1, column2) AGAINST('word1 word2 word3') > 0.001;