The BETWEEN operator chooses values from a predetermined range. The values could be text, integers, or dates.

The BETWEEN operator includes both the begin and finish variables.

Between Syntax

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

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.