fulltext searching

[m n]

------=_NextPart_000_ 000A_01C361A6.A B9BB680
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

How fulltext is working!!?

I have the following table with just one record! And when I do a select
statement, mysql returns no hits!!!

Would you explain to me what is wrong??

Tanks
Cheers!

Adam

CREATE TABLE `mytest` (
`id` int(11) NOT NULL default '0',
`sub` text,
PRIMARY KEY (`id`),
FULLTEXT KEY `sub` (`sub`)
) TYPE=MyISAM;

INSERT INTO `mytest` VALUES (0, 'my name is kalle and i live in the
North');

SELECT * FROM `mytest` WHERE (MATCH (sub) against ("my"));

Not hists!!!???
------=_NextPart_000_ 000A_01C361A6.A B9BB680--