BETWEEN operator #

expr [NOT] BETWEEN a AND b

The BETWEEN operator returns true if its left expression result is between the results of two other expressions on the right (a and b).

Comparison is inclusive, and identical to:

expr >= a AND expr <= b

BETWEEN operator accepts values as consts of the following types: INT, FLOAT, DOUBLE, STRING, INTERVAL, TIMESTAMP and DATE.

BETWEEN operator can be used to define range scan start/stop keys (SELECT FROM WHERE).

select 3 between 1 and 3;
[true]

select id from test where id between 1 and 4;
[1, 2, 3, 4]