SQL list of things LIKE -

this question has answer here:

• is there combination of “like” , “in” in sql? 19 answers

instead of doing query in sql such as:

select quartersection label 'ne%' or label 'sw%' 

is there anyway, can query group values label in ('ne%', 'sw%')?

you can create temp table , put values there, use join

create table tempkeywordsearch (   keyword varchar(20) );  insert tempkeywordsearch  values ('ne%'), ('sw%');  select q.*  quartersection q  join tempkeywordsearch t on (q.col t.keyword);