Basically I want something as easy as  WHERE something LIKE ('too%', '%noo%', 'sooo%') instead of WHERE something LIKE 'too%' OR something LIKE '%noo%' OR something LIKE 'sooo%' Is there any possible way to combine these two things without writing complicated sub-selects?