Code: Select all
SELECT * FROM businesses WHERE MATCH (keywords,description) AGAINST ("foobar") LIMIT 0,5 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 ;