hi afan, depending on your mysql conf you have a minimum word length. check your config for:
ft_min_word_len and change it to 3. hth: lars On 2/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
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]