Trouble with MATCH ... AGAINST in MYSQL
Posted: Mon Jun 23, 2008 6:50 am
I have a table like this:
I have input some records and run a query like following:
The result has no record even the table has two record with the words 'abc' in `module` field.
Who got that? Help me !
Code: Select all
CREATE TABLE `lt_producer` (
`producerID` int(11) unsigned NOT NULL default '0',
`producerName` varchar(50) default NULL,
`producerLogo` varchar(100) default NULL,
`module` text,
`timeupdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`producerID`),
KEY `producerID` (`producerID`),
FULLTEXT KEY `FULLTEXT` (`module`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1Code: Select all
select producerName,module from lt_producer where match(module) against ('abc*');Who got that? Help me !