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)
    -> );

MATCH (col1,col2,...) AGAINST (expr [search_modifier])
A full-text index in MySQL is an index of type FULLTEXT.
Full-text indexes can be used only with MyISAM tables, and
can be created only for CHAR, VARCHAR, or TEXT columns. A
FULLTEXT index definition can be given in the CREATE TABLE
statement when a table is created, or added later using
ALTER TABLE or CREATE INDEX.
For large data sets, it is much faster to load your data
into a table that has no FULLTEXT index and then create the
index after that, than to load data into a table that has an
existing FULLTEXT index.
Full-text searching is performed using MATCH() ... AGAINST
syntax.
MATCH() takes a comma-separated list that names the columns
to be searched.
AGAINST takes a string to search for, and an optional
modifier that indicates what type of search to perform.
Three types of full-text searches
1. A Boolean search interprets the search string using the
rules of a special query language.
2. A natural language search interprets the search string as
a phrase in natural human language (a phrase in free text).
There are no special operators.
3. A query expansion search is a modification of a natural
language search.