mysql 限定时间段范围
startTime: 开始时间
endTime:结束时间
select * from table
where
((start_time > startTime and start_time < endTime)
OR(start_time = startTime and end_time > endTime)
OR(end_time > startTime and end_time < endTime)
OR(start_time = startTime and end_time = endTime)
OR(start_time < startTime and end_time > endTime)
or(start_time > startTime and end_time < endTime)
OR(end_time > startTime and end_time < endTime))