BETWEEN, IN and LIKE are 3 more operators used to filter results (in addition to =, <, > that you already know)

BETWEEN shows the results between two values (usually numbers or dates).

SELECT * FROM products WHERE price BETWEEN 10 AND 20;

Would show all products that cost between 10 and 20. It's the same as

SELECT * FROM products WHERE price >= 10 AND price <= 20;

SELECT column FROM table
WHERE column BETWEEN low AND high