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!!!???
 

Reply via email to