MySQL has support for full-text indexing and searching. A 
full-text index in MySQL is an index of type FULLTEXT. 
FULLTEXT indexes can be used only with MyISAM tables; they 
can be created from CHAR, VARCHAR, or TEXT columns as part 
of a CREATE TABLE statement or added later using ALTER 
TABLE or CREATE INDEX. For large datasets, it is much 
faster to load your data into a table that has no FULLTEXT 
index, and then create the index afterwards, than to load 
data into a table that has an existing FULLTEXT index. 

Constraints on full-text searching are listed in Section 
12.7.4, “Full-Text Restrictions”. 

Full-text searching is performed with the MATCH() function. 

mysql> CREATE TABLE articles (
    ->   id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY 
KEY,
    ->   title VARCHAR(200),
    ->   body TEXT,
    ->   FULLTEXT (title,body)
    -> );