In Syntax:

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,value3,...)

Employee table:

In Example:

SELECT * FROM employee
WHERE name IN ('Samantha', 'Bill', 'Sandra');

In Result: