mysql查询两个时间段的对比

有两种方式
a-b c-d
第一种

SELECT * FROM test_table
WHERE
    (a >= c AND a <= d)
    OR (a <= c AND b >= d)
    OR (b >= c AND b <= d)

第二种

SELECT * FROM test_table
WHERE
    NOT (
        (b < c
        OR (a > d)
    )