You might be interested in these entries too:
WordPress database error: [Can't find FULLTEXT index matching the column list]
SELECT ID, post_title, post_content,MATCH (post_name, post_content) AGAINST ('june 29 2007 on the media friday 29 june 2007') AS score FROM wp_posts WHERE MATCH (post_name, post_content) AGAINST ('june 29 2007 on the media friday 29 june 2007') AND post_date <= '2008-07-25 14:33:48' AND (post_status = 'publish' && ID != '46') AND post_password ='' ORDER BY score DESC LIMIT 5


Responses to 'June 29, 2007 (On The Media: Friday, 29 June 2007)'