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