Final answer:
To add multiple values in a WHERE clause in SQL, use the IN operator to specify a list of values, or chain conditions with the OR operator for the same effect. The IN operator is preferred for readability and simplicity.
Step-by-step explanation:
Adding Multiple Values in SQL WHERE Clause
To add multiple values in a WHERE clause in SQL, you can use either the IN operator or multiple OR conditions. The IN operator allows you to specify a list of values that a column can match. Here's an example using the IN operator:
SELECT * FROM table_name WHERE column_name IN (value1, value2, value3);
Alternatively, you can achieve the same result with multiple OR conditions:
SELECT * FROM table_name WHERE column_name = value1 OR column_name = value2 OR column_name = value3;
The IN operator is generally preferred for readability and simplicity when dealing with multiple values. It's important to note that both methods will retrieve records where the column value matches any one of the specified values in the list.