[Fwd: search issue]

[afan]

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