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!!!???
- Re: fulltext searching Marko Djukic
- Re: fulltext searching Eivind A. Sivertsen
- Re: Re: fulltext searching Egor Egorov
- Re: fulltext searching / BUG report Marko Djukic
- RE: fulltext searching Erlend Hops� Str�msvik
- RE: fulltext searching / BUG report Thomas Spahni
- Re: fulltext searching / BUG report Sergei Golubchik
- FULLTEXT Searching Ralph Guzman
- Re: FULLTEXT Searching Cybot
- Re: FULLTEXT Searching Victoria Reznichenko
- Re: fulltext searching m n
- Re: fulltext searching Roger Baklund
- Re: fulltext searching Victoria Reznichenko
- Re: fulltext searching Roger Baklund
- Fulltext searching Richard Baskett
- RE: Fulltext searching Dathan Vance Pattishall
- Re: Fulltext searching Richard Baskett
- Re: Fulltext searching Michael Stassen
- Re: Fulltext searching Richard Baskett
- RE: Fulltext searching emierzwa
