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... Quote 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.... Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.