Full-Text search
suggest changeIntroduction
MySQL offers FULLTEXT searching. It searches tables with columns containing text for the best matches for words and phrases.
Remarks
FULLTEXT
searching works strangely on tables containing small numbers of rows. So, when you’re experimenting with it, you may find it helpful to obtain a medium-sized table online. Here’s a table of book items, with titles and authors. You can download it, unzip it, and load it into MySQL.
FULLTEXT
search is intended for use with human assistance. It’s designed to yield more matches than an ordinary WHERE column LIKE 'text%'
filtering operation.
FULLTEXT
search is available for MyISAM
tables. It is also available for InnoDB
tables in MySQL version 5.6.4 or later.
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents