From: Date: June 21 2008 3:41pm
Subject: I have a problem when I'm studying the full text search's expansion mode
List-Archive: http://lists.mysql.com/mysql/213428
Message-Id: <69069d7d0806210641s31770eeeq75adcb1ff025a2c8@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_12112_7814025.1214055700328"

------=_Part_12112_7814025.1214055700328
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_12112_7814025.1214055700328--