Hi:
i am trying to run a fulltext query, but it always display nothing, could you help, please.

my query as following:

select * from Thread where Match(Subject,Content) Against("the best casino");

Table

create table Thread(Id smallint auto_increment,
Subject varchar(50),
Content varchar(1000),
CateId smallint,
SubCateId smallint,
DisplayName varchar(30),
link varchar(300),
postTime TIMESTAMP Default CURRENT_TIMESTAMP,
FULLTEXT(Subject,Content),
primary key(Id),
Foreign Key(CateId) References Category(CateId),
Foreign Key(SubCateId) References SubCategory(SubCateId))

insert into Thread (Subject, Content, CateId, SubCateId, DisplayName, link) values
("the best casino", "Best Casino & Best Online Casino 2006-2007 - Allowing Players ...
Not all casinos introduce the best casino game. The importance of game is highest level if you think about the players enjoyment of the game, ...", "1", "2", "bill", "www.nnnnn.com")

-> ("fulltext mysql", "MySQL :: MySQL 5.0 Reference Manual :: 11.8 Full-Text Search Functions
The Wikipedia encyclopedia uses MySQL boolean full text search and MySQL 4.0.20. You can assess the speed yourselves. About 350000 articles/ rows in the ...", "4", "5", "hill", "www.kkkk.com")