数据库的字段 start_time, end_time
输入的字段 a,b
第一种
SELECT * FROM test_tableWHERE
(start_time >= a AND start_time <= b) OR (start_time <= a AND end_time >= b) OR (end_time >= a AND end_time <= b)
第二种
SELECT * FROM test_tableWHERE
NOT (
(end_time < a OR (start_time > b)
)
两种结果相同
