MySQL Forums
Forum List  »  Full-Text Search

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
fulltext indexing problem
3346
September 08, 2005 06:09AM
2039
September 13, 2005 12:32PM
2129
October 15, 2005 12:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.