fulltext indexing problem
Posted by:
it_nb
Date: September 08, 2005 06:09AM
Hi all,
I'm a newbie of full text search.
I created a table articles as following.
mysql> CREATE TABLE articles (
-> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
-> title VARCHAR(200),
-> body TEXT,
-> FULLTEXT (title,body)
-> );
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO articles (title,body) VALUES
-> ('MySQL Tutorial','DBMS stands for DataBase ...'),
-> ('How To Use MySQL Well','After you went through a ...'),
-> ('Optimizing MySQL','In this tutorial we will show ...'),
-> ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
-> ('MySQL vs. YourSQL','In the following database comparison ...'),
-> ('MySQL Security','When configured properly, MySQL ...');
Then I tried to search the row containing "run" , but nothing was found instead of "never run mysqld as root. 2 . .." . What's the problem ?
mysql> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('run' IN BOOLEAN MODE);
Empty set (0.00 sec)
Please help me.
Thank you in advance.