Multiple conditions on same column

[OhLordy]

Hi I have a query similar to this.
SELECT FROM table WHERE column1=1 || column1=2 || column1=3;
but a lot bigger, I was just wondering is there a way of mentioning column1 only once?
like
SELECT FROM table WHERE column1=1 || 2 || 3 ?

Cheers
Rob

[mparab]

I don't think, I think you need to use it each time.

I think,

M🙂