Excuse the basic level of the question, but I have a large SQL query with multiple where clauses, one of which is where I need to filter for:
select * from mytable
where field1= 'value1' OR 'value2' OR 'value3' OR 'value4'
Is there anyway to do the where clause for where the field1 contains multiple options, the way I thought of doing it above doesnt work. Can you do this in a single where clause, or do you need a where clause per possible value. Just somewhat concerned that OR could ignore all the initial logic and treat that as an option for the data in itself.