http://snippets.dzone.com/posts Thu, 24 Jul 2008 23:01:53 GMT DZone Snippets: fulltext code http://snippets.dzone.com/posts/show/122 <code> <br />mysql> CREATE TABLE articles ( <br /> -> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, <br /> -> title VARCHAR(200), <br /> -> body TEXT, <br /> -> FULLTEXT (title,body) <br /> -> ); <br />Query OK, 0 rows affected (0.00 sec) <br /> <br />mysql> INSERT INTO articles (title,body) VALUES <br /> -> ('MySQL Tutorial','DBMS stands for DataBase ...'), <br /> -> ('How To Use MySQL Well','After you went through a ...'), <br /> -> ('Optimizing MySQL','In this tutorial we will show ...'), <br /> -> ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'), <br /> -> ('MySQL vs. YourSQL','In the following database comparison ...'), <br /> -> ('MySQL Security','When configured properly, MySQL ...'); <br />Query OK, 6 rows affected (0.00 sec) <br />Records: 6 Duplicates: 0 Warnings: 0 <br /> <br />mysql> SELECT * FROM articles <br /> -> WHERE MATCH (title,body) AGAINST ('database'); <br />+----+-------------------+------------------------------------------+ <br />| id | title | body | <br />+----+-------------------+------------------------------------------+ <br />| 5 | MySQL vs. YourSQL | In the following database comparison ... | <br />| 1 | MySQL Tutorial | DBMS stands for DataBase ... | <br />+----+-------------------+------------------------------------------+ <br />2 rows in set (0.00 sec) <br /></code> <br /> <br />More information here. <br />http://dev.mysql.com/doc/mysql/en/fulltext-search.html Mon, 11 Apr 2005 03:37:55 GMT http://snippets.dzone.com/posts/show/122 korakot (Korakot Chaovavanich)