The full-text index is one of more useful features of MySQL. About full-text indexes, MySQL assumes that full-text searches will be implemented for sifting through large amounts of natural-language text, it provides a mechanism for retrieving data that produces results that best fit the user’s desired result. More specifically, if a user were to search using a string like "MySQL is the world's most popular open source database", the words 'is' and 'the' should play little or no role in determining result relevance. In fact, MySQL splits searchable text into words, by default eliminating any word of three or less than three characters. However, this behavior can be modified with IN BOOLEAN MODE and WITH QUERY EXPANSION modifiers.

Full Text Indexes Related FAQs

Main features and basic information about full-text search

What are full-text restrictions in MySQL?

On what data types fulltext index can be created?

How to create full-text index in MySQL?

How to create multi columns full-text index in MySQL?

What are natural language and boolean and query expansion full-text searches?

How to use boolean full-text search in MySQL?

How to use full-text searches with query expansion in MySQL?

How to use natural language full-text search in MySQL?

What are stopwords in MySQL?