I have this table
but when I run this query I get an error.
CREATE TABLE `images` (
`id` tinyint(4) NOT NULL auto_increment,
`cid` tinyint(3) NOT NULL default '0',
`name` varchar(20) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`src` varchar(150) NOT NULL default '',
`height` smallint(4) NOT NULL default '0',
`width` smallint(4) NOT NULL default '0',
`transp` enum('no','yes') NOT NULL default 'no',
`keywords` text NOT NULL,
PRIMARY KEY (`id`),
KEY `cid` (`cid`),
FULLTEXT KEY `name` (`name`),
FULLTEXT KEY `description` (`description`),
FULLTEXT KEY `keywords` (`keywords`)
Now I can use full text searching fine on another table but in phpMyAdmin in the indexes list, all the indexs have a cardinality value but in the above table it says none. Could this be causing problems or have I just made a stupid error somewhere?
, match (name, description, keywords) against ('waking') as score
match (name, description, keywords) against ('waking')
Can't find FULLTEXT index matching the column list
Also the table it works on contains ~500 records, this table contains one. I know that'll effect the search results only having one record but that wouldn't be causing the error would it?