Mallory would like to display the rows from a MySQL table that have "Red," "Pink," or "White" in the COLOR column. A concise way of writing her query would be to use a(n) _____.
A) LIKE clause
B) CONTAINS clause
C) BETWEEN clause
D) IN clause

Question

Quizplus · Accepted Answer

The IN clause is used in SQL to specify multiple values in a WHERE condition, making it the most concise way to query rows where the COLOR column is either "Red," "Pink," or "White".

Mallory Would Like to Display the Rows from a MySQL