SELECT column_name(s) FROM table_name WHERE column_name IN (value1, value2, ...);
SELECT column1, column2, ... FROM table_name WHERE condition;
/* AND is a operator that allows you to combine two conditions Both conditions must be true for the row to b e included in the result set */ SELECT column_name(s) FROM table_name WHERE column_1 = value_1 AND column_2 = value_2;
-- example SELECT Id, ProductName, UnitPrice, Package FROM Product WHERE ProductName LIKE 'Cha_' OR ProductName LIKE 'Chan_'
SELECT * FROM Customers WHERE Country='Mexico';