有两种方式
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)
)
有两种方式
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)
)