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)

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

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/mysql?unsub=lists@pantek.com