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值的