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