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 ('art on the lower east side') AS score FROM wp_posts WHERE MATCH (post_name, post_content) AGAINST ('art on the lower east side') AND post_date <= '2009-01-07 00:34:19' AND (post_status = 'publish' && ID != '993') AND post_password ='' ORDER BY score DESC LIMIT 5
Responses to 'Art on the Lower East Side'