SQL - Where clause: comparing a column with multiple values

Question

Is there any generic command or syntax in SQL to allow one to have multiple values in a where statement without using OR? OR just gets tedious when you have many values to choose from and you only want say half of them. I want to return only columns that contain certain values. I am using Cache SQL, but as I said, a generic syntax might be helpful as well because most people are unfamiliar with Cache SQL. Thanks!

Answer 1

You should use IN:

... where column_name in ('val1', 'val2', ...);