MySQL Full-Text Search

In this section, you will learn how to use MySQL full-text search feature. MySQL full-text search provides a simple way to implement various advanced search techniques such as natural language search, Boolean text search and query expansion.

Introduction to MySQL Full-Text Search

code_1
Gives you a brief introduction to MySQL full-text search and its features.

Defining FULLTEXT Indexes for Full-Text Searching

code_31
In this tutorial, you will learn how to define full-text index for columns in database tables before you can perform full-text searches

MySQL Natural Language Search

code_184
Basically in natural language search, MySQL looks for rows or documents which are relevant to the free-text natural human language query, for example "How to use MySQL full-text search".

MySQL Boolean Text Searches

code_7
In this tutorial, you will learn how to use Boolean text searches in MySQL.

Using MySQL Query Expansion

code_43
We show you a very important feature of MySQL full-text search which is known as Query Expansion.