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 '(lower(p.sku_name) LIKE '%ipod%' or lower(p.sku_descriptionA) LIKE '%ipod%' or l' at line 1 MYSQL: select count(*) from products p where p.sku_brand = '596'  &&  p.sku_category IN('199')  && (lower(p.sku_name) LIKE '%ipod%' or lower(p.sku_descriptionA) LIKE '%ipod%' or lower(p.cat_name) LIKE '%ipod%' or lower(p.sku_brandname) LIKE '%ipod%' or lower(p.sku_descriptionB) LIKE '%ipod%')(lower(p.sku_name) LIKE '%ipod%' or lower(p.sku_descriptionA) LIKE '%ipod%' or lower(p.cat_name) LIKE '%ipod%' or lower(p.sku_brandname) LIKE '%ipod%' or lower(p.sku_descriptionB) LIKE '%ipod%')