MySQL – BETWEEN
BETWEEN conditions in MySQL specify a range of values to retrieve from an expression. The statement is used with SELECT, INSERT, UPDATE, and DELETE.
Syntax:
expression BETWEEN value1 AND value2;
expression: Specify a column to be displayed.
value1 and value2: Based on these values, expressions are compared against an inclusive range.
Example:
SELECT * FROM employees WHERE emp_no BETWEEN 10001 AND 10003;