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