mysql 判断两个时间段是否有交集 第一种 ~~~ SELECT * FROM table WHERE (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_table WHERE NOT ( (end_time < a OR start_time > b) ) ~~~ 两种结果相同
Jason 2021-07-15 17:46:32
Nice!