如果一个值是另外两个值,则使用BETWEENbetween
。请注意,“比较之间”包括边界。
WHERE `time` BETWEEN `StartTime` AND `EndTime`
当然不要忘记
CAST(`time` AS TIME)
如果不是这种类型的话TIME
。
要检查范围:
WHERE
(CAST(`rangeStart` AS TIME) BETWEEN `StartTime` AND `EndTime`) AND
(CAST(`rangeEnd` AS TIME) BETWEEN `StartTime` AND `EndTime`)