Discuss / SQL / between...and
Back

between...and

Topic source

21世纪全球最具影响力人物97856

#1 Created at ... [Delete] [Delete and Lock User]

我记得between..and 是左闭右开的啊

廖雪峰

#2 Created at ... [Delete] [Delete and Lock User]

记不记得无所谓，关键要会确认：

https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html#operator_between

廖雪峰

#3 Created at ... [Delete] [Delete and Lock User]

`expr` BETWEEN `min` AND `max`

If expr is greater than or equal to min and expr is less than or equal to max, BETWEEN returns 1, otherwise it returns 0. This is equivalent to the expression (`min` <= `expr` AND `expr` <= `max`)

看最后一句

白露

#4 Created at ... [Delete] [Delete and Lock User]

我也记得是左闭右开的区间，难道我的记忆混乱了吗

  • 1

Reply