BETWEEN
The BETWEEN operator selects values within a given range. The values can be numbers, text, or dates.
The BETWEEN operator is inclusive: begin and end values are included.
Example
SELECT * FROM Products
WHERE Price BETWEEN 10 AND 15;
BETWEEN Text Values
The BETWEEN operator can also be used on text values.
The result returns all records that are alphabetically between the specified values.
Example
SELECT * FROM Products
WHERE product_name BETWEEN 'Pavlova' AND 'Tofu';
If we add an ORDER BY clause to the example above, it will be a bit easier to read:
Example
SELECT * FROM Products
WHERE product_name BETWEEN 'Pavlova' AND 'Tofu'
ORDER BY product_name;
BETWEEN Date Values
The BETWEEN operator can also be used on date values.
Example
SELECT * FROM orders
WHERE order_date BETWEEN '2023-04-12' AND '2023-05-05';
