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 '<> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `s' at line 1(No Description) sql: SELECT *, MATCH (description, keyfeatures, title) AGAINST ('divorce' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('divorce' IN BOOLEAN MODE) AND <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3