470,641 Members | 1,584 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,641 developers. It's quick & easy.

fulltext searching

m n
------=_NextPart_000_000A_01C361A6.AB9BB680
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.AB9BB680--
Jul 19 '05 #1
0 1760

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by JT | last post: by
reply views Thread by Ralph Guzman | last post: by
reply views Thread by Matt W | last post: by
8 posts views Thread by Radim B | last post: by
reply views Thread by Phil Powell | last post: by
1 post views Thread by Mike Reef | last post: by
reply views Thread by Alex Glass | last post: by
1 post views Thread by Robert Oschler | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.