Put missing cd's in the search of the knowledge base and got this.... Query: select *, match(message_synopsis, message_content) against('missing cd's') as score from message where (message_inknowledgebase = 1 and message_categories like '%Support~Vue 4 Professional~an issue not listed here%') and (match(message_synopsis, message_content) against('missing cd's') >= 0.707) order by score desc limit 0, 2 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's') as score from message where (message_inknowledgebase = 1 an