BETWEEN, NOT BETWEEN

BETWEEN and NOT BETWEEN check if values are in or not in a range that includes the two endpoints. For example:

SQL

CREATE TABLE bet_r(t TEXT);
INSERT bet_r VALUES("blue"), ("orange"), ("yellow");

SQL

SELECT * FROM bet_r WHERE t BETWEEN "blue" AND "pink";

+--------+
| t      |
+--------+
| blue   |
| orange |
+--------+

Last modified: February 28, 2023

Was this article helpful?