Page 1 of 1

Full text indexing... what am I doing wrong?

Posted: Mon Oct 02, 2006 1:27 pm
by Luke
I have used full-text indexing before in mysql, but for some reason, this query is not working... can somebody please tell me what I'm doing wrong?

Code: Select all

SELECT * FROM businesses WHERE MATCH (keywords,description) AGAINST ("foobar") LIMIT 0,5  
I have tried so many different things... nothing works... here is my schema:

Code: Select all

CREATE TABLE `businesses` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `owner` varchar(50) NOT NULL default '',
  `contact_name` varchar(50) NOT NULL default '',
  `contact_title` varchar(25) NOT NULL default '',
  `address` varchar(50) NOT NULL default '',
  `address2` varchar(50) default NULL,
  `city` varchar(25) NOT NULL default '',
  `state` char(2) NOT NULL default 'CA',
  `zip` int(9) NOT NULL default '0',
  `phone` varchar(10) NOT NULL default '0',
  `alt_phone` varchar(10) default '0',
  `fax` varchar(10) default '0',
  `email` varchar(50) NOT NULL default '',
  `website` varchar(100) default NULL,
  `description_short` tinytext,
  `description` text NOT NULL,
  `season` varchar(30) default NULL,
  `hours` varchar(100) default NULL,
  `created` varchar(15) NOT NULL default '',
  `modified` varchar(15) NOT NULL default '',
  `suspended` varchar(15) default NULL,
  `county` varchar(10) default NULL,
  `type` varchar(50) default NULL,
  `keywords` mediumtext,
  `corridor` varchar(20) default NULL,
  `point_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`),
  FULLTEXT KEY `keywords` (`keywords`),
  FULLTEXT KEY `description` (`description`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;

Posted: Mon Oct 02, 2006 1:28 pm
by Luke
dammit... I did it again... i figured it out as soon as I posted... I was trying to use two indexes in one query... I combined the two full-text indexes and it works now... sorry mods. :oops: