The official table's data. +----+-----------------------+-------------------------------------+ | id | title | body | +----+-----------------------+-------------------------------------+ | 1 | MySQL Tutorial | DBMS stands for DataBase ... | | 2 | How To Use MySQL Well | After you went through a ... | | 3 | Optimizing MySQL | In this tutorial we will show ... | | 4 | 1001 MySQL Tricks | 1. Never run mysqld as root. 2. ... | | 6 | MySQL Security | When configured properly, MySQL ... | +----+-----------------------+-------------------------------------+ But the expansion mode is explained as follows. mysql> *SELECT * FROM articles* -> *WHERE MATCH (title,body)* -> *AGAINST ('database' IN NATURAL LANGUAGE MODE);* +----+-------------------+------------------------------------------+ | id | title | body | +----+-------------------+------------------------------------------+ | 5 | MySQL vs. YourSQL | In the following database comparison ... | | 1 | MySQL Tutorial | DBMS stands for DataBase ... | +----+-------------------+------------------------------------------+ 2 rows in set (0.00 sec)
mysql> *SELECT * FROM articles* -> *WHERE MATCH (title,body)* -> *AGAINST ('database' WITH QUERY EXPANSION);* +----+-------------------+------------------------------------------+ | id | title | body | +----+-------------------+------------------------------------------+ | 1 | MySQL Tutorial | DBMS stands for DataBase ... | | 5 | MySQL vs. YourSQL | In the following database comparison ... | | 3 | Optimizing MySQL | In this tutorial we will show ... | +----+-------------------+------------------------------------------+ 3 rows in set (0.00 sec) Why not id equals 2 and 4 didn't display in the result.They all include the word mysql. -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn