This blog shows how to use a list of values as a condition in a single column with the where clause using IN operator
Syntax:
Select Column_list
From table
Where Column1 IN ('Value1', 'Value2', 'Value3')
Example
Select EmpName, EMpSal
From EmpSal
Where EmpID IN ('1','2','3')