Time : 10:08:58 SQLSTATE[42000]: Syntax error or access violation: 1064 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 'and LOWER(productName) = ?' at line 1 Raw SQL : select productId from product where category= and LOWER(productName) = :productName Time : 10:01:22 SQLSTATE[42000]: Syntax error or access violation: 1064 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 'and LOWER(productName) = ?' at line 1 Raw SQL : select productId from product where and LOWER(productName) = :productName