如果一个值是另外两个值，则使用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`)
602392714
清零编程群