MySQL Full-text search fulltext

MySQL Full-text search fulltext

To create the table 111CN first
You design the field, as long as there are title,body these two on the line,
Then MySQL or phpMyAdmin run one side statement
ALTER TABLE ' 111CN ' Add fulltext (' title ', ' Body ');

So we added a title and body combination Fulltext,

Here's an example.

SELECT Id,title, MATCH (title,body) against (' + 2010 Calendar calendars Calendar +youer ') from 111CN limit 0,5

Time consuming 0.09

SELECT * from ' 111CN ' WHERE to title like '% 2010 Calendar calendars% ' or body like '% 2010 Calendar calendars% ' 0,5

Time consuming 0.09

Just like the same as like

This test has only 500 data, if the above gap is big,
Note MySQL Full-text search only MyISAM storage way, remember InnoDB is not support Full-text search OH.