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
)
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html
一句话: MYSQL BETWEEN 是包含 Min 和 Max值的