Full text search returns nothing.
Posted by:
Zeya B
Date: May 19, 2005 12:58AM
Here is the schema:
CREATE TABLE `cp_clippings` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`cp_ID` bigint(20) NOT NULL default '0',
`User_ID` bigint(20) NOT NULL default '0',
`Title` varchar(255) NOT NULL default '',
`URL` text NOT NULL,
`Clipping` text,
`Comments` text,
`Folder_Id` int(10) unsigned default '0',
`IsActive` tinyint(1) default '1',
`IsPublic` tinyint(1) default '0',
`Created_By` varchar(75) default NULL,
`Created_Date` datetime default NULL,
`Modified_By` varchar(75) default NULL,
`Modified_Date` datetime default NULL,
PRIMARY KEY (`ID`,`cp_ID`),
FULLTEXT KEY `ClippingsFulltext` (`Title`,`URL`,`Clipping`,`Comments`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED COMMENT='MyISAM Table '
And here is the query that does not return any row for me.
SELECT title, url, clipping, comments,
MATCH (Title,URL,Clipping,comments) AGAINST ('mysql') AS score
FROM cp_clippings where
MATCH (Title,URL,Clipping,comments) AGAINST ('mysql')
There are enough rows that has - "mysql" and other longer words that I tried to search for but to no avail.
Any suggestions? Am I missing something? I am using MySQL 4.1.10.
Thanks.