Posted by Maziar Aflatoun on 05/16/05 02:47

Hi,

I have the following table

CREATE TABLE `fulltext_sample` (
`copy` text,
FULLTEXT KEY `copy` (`copy`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `fulltext_sample` VALUES ('This is a test to see how mysql
works');

Now I do a search for
SELECT * FROM fulltext_sample WHERE MATCH(copy) AGAINST('mysql');
and it return 0 results. Can someone please help me with this?

Thanks
Maz.

• Next in forum: Re: PHP and FRAMES?
• Prev in forum: PHP MySQL
• Thread view: MySQL WHERE MATCH problem

[Reply to this message]