Skip to main content

MATCH ... AGAINST

Learn MATCH ... AGAINST (Full-Text Search, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction MATCH(col1, col2) AGAINST('words' [mode]) is the query side of a FULLTEXT index. In a WHERE clause it filters; in a SELECT list it returns a floating-point relevance score (0 means no match). The default mode is natural language.

More lessons in Full-Text Search