Description:
When doing a fulltext search for the keyword "less", it seems that MySQL ignores this keyword.
How to repeat:
CREATE TABLE seller (
id int(10) unsigned NOT NULL auto_increment,
name varchar(50) default NULL,
address varchar(150) default NULL,
zipcode int(5) default NULL,
website varchar(100) default NULL,
phone varchar(25) default NULL,
seller_type varchar(10) default NULL,
seller_status varchar(10) default NULL,
overall_rating float NOT NULL default '0',
fax varchar(25) default NULL,
support_phone varchar(25) default NULL,
support_email varchar(50) default NULL,
business_hours varchar(100) default NULL,
comments int(10) unsigned NOT NULL default '0',
referral_url varchar(255) default NULL,
submission_status tinyint(1) unsigned NOT NULL default '1',
popup_agreement tinyint(1) unsigned NOT NULL default '0',
update1 tinyint(4) NOT NULL default '0',
update2 tinyint(4) NOT NULL default '0',
update3 tinyint(4) NOT NULL default '0',
update4 tinyint(1) NOT NULL default '0',
update5 tinyint(1) NOT NULL default '0',
update6 tinyint(1) NOT NULL default '0',
features bigint(5) NOT NULL default '0',
PRIMARY KEY (id),
KEY seller_type (seller_type),
KEY seller_status (seller_status),
KEY overall_rating (overall_rating),
FULLTEXT KEY website (website),
FULLTEXT KEY name (name)
) TYPE=MyISAM;
#
# Dumping data for table `seller`
#
INSERT INTO seller VALUES (33, 'Ram 4 less', NULL, NULL, 'http://www.ram4less.com', NULL, 'member', 'active', '0', NULL, NULL, NULL, NULL, 5, NULL, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO seller VALUES (249, 'Computers for Less', NULL, NULL, 'http://www.shopsite.com', NULL, 'member', 'active', '0', NULL, NULL, NULL, NULL, 7, NULL, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO seller VALUES (344, 'Less Stuff', NULL, 0, 'http://www.1shopsite.com', '', 'member', 'active', '0', NULL, '', '', NULL, 7, NULL, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO seller VALUES (55, 'New Data Concepts', NULL, NULL, 'http://www.cris.com/~ndc', NULL, 'member', 'active', '0', NULL, NULL, NULL, NULL, 1, NULL, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO seller VALUES (81, 'Storage USA (New MMI)', NULL, NULL, 'http://www.storageusa.com\n', NULL, 'member', 'active', '0', NULL, NULL, NULL, NULL, 2, NULL, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO seller VALUES (833, 'Brian Newgent Bad Ass PC', NULL, NULL, 'http://www.badasspc.com', NULL, 'member', 'active', '0', NULL, NULL, NULL, NULL, 1, NULL, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO seller VALUES (56, 'Of all things New', NULL, NULL, 'http://www.newthings.net', NULL, 'member', 'active', '0', NULL, NULL, NULL, NULL, 1, NULL, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO seller VALUES (355, 'Mass Stuff', NULL, 0, 'http://www.1shopsite.com', '', 'member', 'active', '0', NULL, '', '', NULL, 7, NULL, 1, 0, 0, 0, 0, 0, 0, 0, 0);
SELECT name FROM seller WHERE MATCH (name) AGAINST ('mass');
SELECT name FROM seller WHERE MATCH (name) AGAINST ('less');
There are two records with name fields of Mass Stuff and Less Stuff. When using "mass" as the fulltext search keyword, the Mass Stuff record is matched. When using "less" as the fulltext search keyword, no records are matched, when the Less Stuff record should be matched.
