Don't forget that LIKE "%cap%" will find "captain", "recapture", and anything else that has the substring "cap" in it. Your Boolean match against "+cap" will only find the word "cap". Make sure that's what you want.
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 13, 2007 9:43 AM > To: mysql@lists.mysql.com > Subject: [Fwd: search issue] > > hi to all! > > I'm trying to get some products from products table using > fulltext search > but something doesn't work correctly - and can't find what. > > this is table products: > CREATE TABLE `products` ( > `prod_id` int(8) unsigned NOT NULL auto_increment, > `prod_no` varchar(50) NOT NULL default '', > `prod_name` varchar(255) NOT NULL default '', > `prod_description` text, > `prod_colors` text, > `prod_includes` text, > `prod_catalog` varchar(45) default NULL, > `prod_status` enum('hidden','live','new') NOT NULL default 'new', > `prod_supplier` varchar(45) default NULL, > `prod_start_date` date default '0000-00-00', > `prod_end_date` date default '0000-00-00', > `prod_featured` enum('0','1') default NULL, > `on_sale` enum('Yes','No') NOT NULL default 'No', > PRIMARY KEY (`prod_id`), > UNIQUE KEY `prod_no` (`prod_no`), > KEY `products_index1` (`prod_status`), > KEY `products_index2` (`prod_start_date`,`prod_end_date`), > KEY `on_sale` (`on_sale`), > FULLTEXT KEY `prod_search` (`prod_name`,`prod_description`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9119 ; > > > table products has 5168 records. > > when search for products that hav 'cap' in product name, > using smple LIKE > function: > select prod_id, prod_no, prod_name, prod_status > from products > where prod_name like '%cap%' > I get 79 rows. > > when try: > select prod_id, prod_name, prod_no > from products > where MATCH (prod_name) AGAINST ('+cap' in boolean mode) > I don't get any record as result. > > What I'm doing wrong? > > > Thanks for any help. > > -afan > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
