MySQL Full-Text Search support

2. MySQL Full-Text Search support
6. More than 4.0 MySQL MyISAM engine supports full text search, which can be used to support search on a typical small website or blog.
8. So how to use, simple look:
12. 1. Create a table that specifies the columns that support fulltext
16. CREATE TABLE Articles (
18. ID INT UNSIGNED auto_increment not NULL PRIMARY KEY,
20. Title VARCHAR (200),
22. Body TEXT,
24. Fulltext (Title,body)
26. );
30. 2. Insert some data as a test
34. INSERT into articles (Title,body) VALUES
36. (' MySQL Tutorial ', ' DBMS stands for DataBase ... '),
38. (' How to use the MySQL well ', ' after you went through a ... '),
40. (' Optimizing MySQL ', ' in this tutorial we'll show ... '),
42. (' 1001 MySQL Tricks ', ' 1. Never run mysqld as root. 2 ... '),
44. (' MySQL vs. Yoursql ', ' in the following database comparison ... '),
46. (' MySQL Security ', ' when configured properly, MySQL ... ');
50. 3.select Query fulltext Columns
54. SELECT * from articles
56. WHERE MATCH (title,body) against (' database ');
60. Query Result:
64. 5 MySQL vs. Yoursql in the following database comparison ...
66. 1 MySQL Tutorial DBMS stands for DataBase ...
70. A Boolean statement in a full-text query, +-as with normal search engine syntax
74. SELECT * from articles WHERE MATCH (title,body)
76. Against (' +mysql-yoursql ' in BOOLEAN MODE);
80. InnoDB does not support Fulltext, of course, you can use Http://sphinxsearch.com/sphinx to dump database data to support full-text search.

MySQL Full-Text Search support