SELECT TR_ID,Title,RetailPrice,AffiliateCode FROM media_data WHERE RetailPrice > 0 AND MATCH(Title) AGAINST ('+Brothers +In +Arms +3: +Hell's +Highway' IN BOOLEAN MODE) AND ( Category='Wii' OR Category='Video Games / Nintendo Wii') 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 +Highway' IN BOOLEAN MODE) AND ( Category='Wii' OR Category='Video Games / Nin' at line 1