Code: Select all
CREATE TABLE `products` (
`id` int(10) unsigned NOT NULL auto_increment,
`product_id` varchar(100) NOT NULL default '',
`username` varchar(30) NOT NULL default '',
`product_name` varchar(30) NOT NULL default '',
`quantity` smallint(5) unsigned NOT NULL default '0',
`description` text NOT NULL,
`keywords` varchar(255) NOT NULL default '',
`special` text NOT NULL,
`main_category` varchar(35) NOT NULL default '',
`sub_category` varchar(35) NOT NULL default '',
`price` int(11) NOT NULL default '0',
`hits` int(10) unsigned NOT NULL default '0',
`search_hits` int(10) unsigned NOT NULL default '0',
`store_name` varchar(40) default NULL,
`store_owner` varchar(30) default NULL,
`store_email` varchar(50) default NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`,`store_name`),
FULLTEXT KEY `product_name` (`product_name`),
FULLTEXT KEY `description` (`description`),
FULLTEXT KEY `keywords` (`keywords`),
FULLTEXT KEY `product_name_2` (`product_name`,`description`,`keywords`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;Code: Select all
SELECT * FROM products;Code: Select all
SELECT * FROM products WHERE MATCH(description) AGAINST('product')Any ideas to why?