BETWEEN, NOT BETWEEN
BETWEEN
and NOT BETWEEN
check if values are in or not in a range that includes the two endpoints. For example:
CREATE TABLE bet_r(t TEXT); INSERT bet_r VALUES("blue"), ("orange"), ("yellow");
SELECT * FROM bet_r WHERE t BETWEEN "blue" AND "pink"; **** +--------+ | t | +--------+ | blue | | orange | +--------+