Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
BETWEEN, NOT BETWEEN
BETWEEN
and NOT BETWEEN
check if values are in or not in a range that includes the two endpoints (inclusive).
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