FULLTEXT should be working...
Posted: Mon Jan 24, 2005 2:57 am
Table Structure:
Now, there is the product_name_2 in there, I can only guess because there is already one for product_name defined. In "MySQL" by DuBois, it says that there should be one for each column you want to search, plus one for all in case I am going to search one or the other sometimes, and all of em sometimes.
Regardless of all the other stuff, the column description comes back with "This is a really great product for you to buy. It does a lot of things you think are not as cool as you think."
Should come back with something, comes back with nothing. 
Any ideas to why?
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?