ToonMariner Posted December 15, 2007 Share Posted December 15, 2007 I have the following query... SELECT `media`.* , `user`.`username`, DATEDIFF(NOW(), `media`.`added`) AS `period` FROM `media` , `user` WHERE `media`.`flag` != 'm' AND `user`.`user_id` = `media`.`user_id` AND ( MATCH ( `media`.`search`, `media`.`title` ) AGAINST ('radio') OR `title` LIKE '%radio%' ) I have `media`is a MyISAM table and i have placed a fulltext index on the search amd title fields. Could anyone be so kind as to point out what I am doing wrong??? Thanks people... Link to comment https://forums.phpfreaks.com/topic/81814-solved-cant-find-fulltext-index-matching-the-column-list/ Share on other sites More sharing options...
ToonMariner Posted December 16, 2007 Author Share Posted December 16, 2007 Its OK I missed 'IN BOOLEAN MODE' from the match clause.... Link to comment https://forums.phpfreaks.com/topic/81814-solved-cant-find-fulltext-index-matching-the-column-list/#findComment-415889 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.