As of MySQL 3.23.23, MySQL has support for full-text indexing
and searching.  A full-text index in MySQL is an index of type
FULLTEXT.  FULLTEXT indexes are used with MyISAM tables
only and can be created from CHAR, VARCHAR,
or TEXT columns at CREATE TABLE time or added later with
ALTER TABLE or CREATE INDEX.  For large datasets, it will be
much faster to load your data into a table that has no FULLTEXT
index, then create the index with ALTER TABLE (or
CREATE INDEX).  Loading data into a table that already has a
FULLTEXT index could be significantly slower.
