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%')
Here is the table:
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