search index
In MySQL, full-text search queries use a special kind of index, the FULLTEXT index. In MariaDB 5.6.4 and up, InnoDB
and MyISAM
tables both support FULLTEXT
indexes; formerly, these indexes were only available for MyISAM
tables.
See also FULLTEXT index.