Select ..... where .... OR

Sure thing, the simplest way is this:

select foo from bar where baz in (1,2,3)

OR:

SELECT foo FROM bar WHERE baz BETWEEN 1 AND 3

select * from TABLE where field IN (1,2,3)

You can also conveniently combine this with a subquery that only returns one field:

    select * from TABLE where field IN (SELECT boom FROM anotherTable)

Related