Search results
MySQL full-text search supports advanced search features such as boolean operators, phrase searches, and sorting the search result by relevance. In addition, it comes with built-in stopword removal and enables custom dictionaries and word stemming for enhanced search capability.
Full-text searching is performed using MATCH() AGAINST() syntax. MATCH() takes a comma-separated list that names the columns to be searched. AGAINST takes a string to search for, and an optional modifier that indicates what type of search to perform.
This is the MySQL Tutorial from the MySQL 5.7 Reference Manual.
These search types are described in Section 14.9.2, “Boolean Full-Text Searches”, and Section 14.9.3, “Full-Text Searches with Query Expansion”. A full-text search that uses an index can name columns only from a single table in the MATCH() clause because an index cannot span multiple tables.
Three Types of Full-Text Searches Natural Language Full-Text Searches Boolean Full-Text Searches Full-Text Searches with Query Expansion
In this tutorial, you will learn about MySQL natural language full-text search by using the MATCH() and AGAINST() functions.
MySQL Full-Text Search. To perform a Full-Text Search on a MySQL table, we use MATCH () and AGAINST () functions in a WHERE clause of an SQL SELECT statement. Stop words are words that are commonly used (such as 'on', 'the', or, 'it') in sentences and will be ignored during the searching process.
