Full-text search index MySQL ?


The full-text index is an index of FULLTEXT type, it can be used only with InnoDB or MyISAM table Storage Engine,
and support only for CHAR, VARCHAR, or TEXT columns.

Full-Text Search Functions

  1. Natural Language Full-Text Searches
  2. Boolean Full-Text Searches
  3. Full-Text Searches with Query Expansion

Syntax

MATCH (col1,col2,col3,...) AGAINST (expr [search_modifier])
search_modifier:
  {
      IN NATURAL LANGUAGE MODE
     | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION
     | IN BOOLEAN MODE
     | WITH QUERY EXPANSION
  }


Related

find the nth highest salary in mysql without limit
How to find greater than average salary records in MySQL
how to find duplicate records in MySQL query
How to use second index forcefully in MySQL
How to get total number of rows in MySQL table with and without count