Hi,
There are some words which are drawn as "Stop words" [Words which are not
searchable in Fulltext Database]. To know the list of stopwords,
http://dev.mysql.com/tech-resources/articles/full-text-revealed.html.
"hello" is a stopword, and hence your query fails to return rows.
Thanks
ViSolve DB Team
----- Original Message -----
From: "Niu Kun" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Sunday, July 01, 2007 7:53 AM
Subject: Re: Problem about fulltext search.
Steve Edberg wrote:
At 11:23 PM +0800 6/30/07, Niu Kun wrote:
To quote from
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
"... words that are present in more than 50% of the rows are considered
common and do not match."
'hello' appears in both (100%) of your records above, so it will not
match. You need to insert more test data before MySQL has enough words
to compute valid relevances.
steve
Thank you for your advice.
And again, I've got the following command.
mysql> insert into test values(1,"aaa");
Query OK, 1 row affected (0.00 sec)
mysql> insert into test values(1,"aaa");
Query OK, 1 row affected (0.00 sec)
mysql> insert into test values(1,"aaa");
Query OK, 1 row affected (0.00 sec)
mysql> insert into test values(1,"aaa");
Query OK, 1 row affected (0.00 sec)
mysql> insert into test values(1,"aaa");
Query OK, 1 row affected (0.00 sec)
mysql> select * from test where match(name) against("hello");
Empty set (0.00 sec)
mysql> select * from test where match(name) against("hello" in boolean
mode);
Empty set (0.00 sec)
mysql> select * from test where match(name) against("world" in boolean
mode);
+------+-------------+
| id | name |
+------+-------------+
| 1 | hello world |
+------+-------------+
1 row in set (0.00 sec)
It seems that hello can't be found.
But world can be found.
I wonder if mysql has restrictions on the word to be found.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.9.14/883 - Release Date: 7/1/2007
12:19 PM
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
