入参: newStartTime newEndTime
方法一:
select * from table
where
(start_time >= newStartTime and start_time <= newEndTime)
or (start_time <= newStartTime and end_time >= newEndTime)
or (end_time >= newStartTime and end_time <= newEndTime)
方法二,逆向思维,找完全不重叠的相反情况
select * from table where not( (end_time < newStartTime )or ( start_time > newEndTime) )