Select where OR Condition
Is there a way to select data where any one of multiple conditions occur on the same field?
Example: I would typically write a statement such as:
select * from TABLE where field = 1 or field = 2 or field = 3
Is there a way to instead say something like:
select * from TABLE where field = 1 || 2 || 3
Any help is appreciated.
Answer:
Sure thing, the simplest way is this:
select foo from bar where baz in (1,2,3)