Re: Trying fulltext search

2004-09-21 Thread Thomas Spahni
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_file

Trying fulltext search

2004-09-20 Thread Randy Paries
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 va