Skip to main content

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 |
+--------+