Hi,
Try:
select * from test where match(name) against("hello" in boolean mode);
Octavian
----- Original Message -----
From: "Niu Kun" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Saturday, June 30, 2007 6:23 PM
Subject: Problem about fulltext search.
Dear all,
I'm planning to add fulltext search to my database.
I've got the following test command:
create table test(id int, name varchar(20));
alter table test add fulltext(name);
insert into test values(1,"hello world");
insert into test values(1,"hello");
When I execute the fulltext search command, I've got the following.
mysql> select * from test where match(name) against("hello");
Empty set (0.00 sec)
Would anyone be kind enough to tell me how I can find hello in my text?
Any help would be appreciated.
Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
