mysql的between的边界，范围

最新推荐文章于 2024-08-16 08:38:01 发布

markix

最新推荐文章于 2024-08-16 08:38:01 发布

阅读量2.1w

点赞数 9

分类专栏：数据库文章标签： mysql between not between 边界范围

本文为博主原创文章，未经博主允许不得转载。

本文链接：https://blog.csdn.net/qq_31772441/article/details/80365585

版权

数据库专栏收录该内容

13 篇文章 0 订阅

订阅专栏

between 的范围是包含两边的边界值
eg： id between 3 and 7 等价与 id >=3 and id<=7
not between 的范围是不包含边界值
eg：id not between 3 and 7 等价与 id < 3 or id>7

SELECT * FROM `test` where id BETWEEN 3 and 7;
等价于 SELECT * FROM `test` where id>=3 and id<=7;
-----------------------------------------------------------
SELECT * FROM `test` where id NOT BETWEEN 3 and 7;
等价于 SELECT * FROM `test` where id<3 or id>7;