String concatenation

Join strings with ||.

BETWEEN and IN

BETWEEN filters a range, IN a list. BETWEEN includes the endpoints.

SELECT name FROM products
WHERE price BETWEEN 10 AND 50
  AND category IN ('kitap', 'kırtasiye');

Price between 10 and 50 and category is book or stationery.

name is selected from products. WHERE keeps only the rows where price BETWEEN 10 AND 50 AND category IN ('kitap', … holds.

IN is shorter than many OR. BETWEEN is equivalent to >= AND <=.

Select names from products where price is between 10 and 50.

Show example solution

SELECT name
FROM products
WHERE price BETWEEN 10 AND 50

Filter list

SELECT name FROM customers
WHERE city ____ ('İzmir', 'Bursa');

Show answer

SELECT name FROM customers
WHERE city IN ('İzmir', 'Bursa');