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 'IN(8, 25, 27, 32, 35, 36, 39, 42, 48)) AND ( UPPER(`GIVEN_NAME`) LIKE ('%SIMON%'' at line 1 SQL=SELECT COUNT(*) FROM `view_member_lodge_combined_prefix` WHERE (IN(8, 25, 27, 32, 35, 36, 39, 42, 48)) AND ( UPPER(`GIVEN_NAME`) LIKE ('%SIMON%') );