MATCH ... AGAINST Syntax

MATCH AGAINST

Use MATCH(columns) AGAINST('query') to search full-text indexes. Returns a relevance score for each row.

Example

SELECT id, title,
       MATCH(title, body) AGAINST('mysql performance') AS score
FROM articles
WHERE MATCH(title, body) AGAINST('mysql performance')
ORDER BY score DESC;

SQL

Full Editor

Pro Tip

Use MATCH in both SELECT and WHERE for efficiency — MySQL uses the index once.

Related Resources

MySQL Reference

Complete tag & property list

MySQL How-To Guides

Step-by-step practical guides

MySQL Exercises

Practice what you've learned