Loading lesson path
Concept visual
Start at both ends
operator is used in the WHERE clause to check if a specified column's value matches any value within a provided list.
operator functions as a shorthand for multiple OR conditions, making queries shorter and more readable.
operator to select all customers from Germany, France, or UK:
SELECT * FROM Customers
WHERE Country IN ('Germany', 'France', 'UK');OR conditions to select all customers from Germany, France, or UK (same result, but longer code):
SELECT * FROM Customers
WHERE Country = 'Germany' OR Country = 'France' OR Country = 'UK';column_name(s)
table_name
column_name IN (
value1, value2, ...);Customers table used in the examples:
Obere Str. 57
12209