SELECT TR_ID,Title,RetailPrice,AffiliateCode FROM media_data WHERE RetailPrice > 0 AND MATCH(Title) AGAINST ('+om +Clancy's +EndWar' IN BOOLEAN MODE) AND ( Category='Xbox 360' OR Category='Video Games / Microsoft Xbox 360' OR Category='Consoles / Microsoft Xbox 360' OR Category='Console Accessories / Microsoft Xbox 360' OR Category='Video Games Microsoft Xbox 360') LIMIT 0,20 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 +EndWar' IN BOOLEAN MODE) AND ( Category='Xbox 360' OR Category='Video Games /' at line 1