Using SQL LIKE and IN together March 31, 2023 by Tarik How about using a substring with IN. select * from tablename where substring(column,1,4) IN ('M510','M615','M515','M612')