BETWEEN, NOT BETWEEN

BETWEEN and NOT BETWEEN check if values are in or not in a range that includes the two endpoints (inclusive). 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 |
+--------+

Last modified: January 9, 2024

Was this article helpful?