Full text search returns an empty string, can't understand

oliflorence · #1 (**permalink**) 04-10-08, 07:40

Hello,
I have an sql search with data in a table which should be returned. However the I am getting an empty set back.
I enclose below the SQL I am using and the table:

Code:

SELECT poisonId, poison, latin_name, short_desc, status FROM tblpoisons WHERE MATCH (poison,latin_name,short_desc,full_desc) AGAINST ('%poison%')

Code:

CREATE TABLE `tblpoisons` (
  `poisonId` int(11) NOT NULL auto_increment,
  `catId` int(11) default NULL,
  `poison` varchar(150) default NULL,
  `latin_name` varchar(150) default NULL,
  `short_desc` varchar(250) default NULL,
  `Full_desc` mediumtext,
  `status` tinyint(1) default NULL,
  PRIMARY KEY  (`poisonId`),
  FULLTEXT KEY `searchindex` (`poison`,`latin_name`,`short_desc`,`Full_desc`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

Many thanks in advance
Olivier

Internet Services

Web Development

Digital Marketing

Consumer Tech