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]
