Randy,
could it be that the word 'bird' appears in more than half of all rows in
your dataset? I strongly recommend to spend a few minutes reading the
manual about Fulltext Search.
Regards,
Thomas
On Mon, 20 Sep 2004, Randy Paries wrote:
> Hello
>
> I have a table
> CREATE TABLE community_files (
> id int(3) unsigned NOT NULL auto_increment,
> type int(10) unsigned NOT NULL default '0',
> category_id int(10) unsigned NOT NULL default '0',
> filename varchar(50) NOT NULL default '',
> path varchar(255) NOT NULL default '',
> description varchar(255) NOT NULL default '',
> PRIMARY KEY (id),
> UNIQUE KEY id (id),
> KEY id_2 (id),
> KEY type (type),
> KEY catid (category_id),
> FULLTEXT KEY description (description)
> ) TYPE=MyISAM;
>
> Where I run a query like
> select * from community_files where description like '%bird%';
>
> I get records back, but if I try to do
> SELECT * FROM community_files WHERE MATCH (description) AGAINST ('bird' );
> I get nothing back
>
> I am running mysqld Ver 3.23.58 on rh9
>
> Thanks for any help
>
> Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
