Code: Select all
SELECT *, MATCH (keywords) AGAINST ('".addslashes($query)."') AS score FROM mudcrawl WHERE MATCH (keywords) AGAINST ('".addslashes($query)."' IN BOOLEAN MODE)Code: Select all
# Host: localhost
# Database: mudsearch
# Table: 'mudcrawl'
#
CREATE TABLE `mudcrawl` (
`filename` varchar(200) default NULL,
`fileurl` varchar(200) default NULL,
`keywords` longtext,
FULLTEXT KEY `keywords` (`keywords`,`filename`)
) TYPE=MyISAM;Code: Select all
Can't find FULLTEXT index matching the column list