场景:每天只能存在一个时间段的公告,添加公告时,不能添加有交集的公告信息
SET @a = '2020-06-17 20:00:00';
SET @b = '2020-06-28 00:00:00';
SELECT
*
FROM
test
WHERE
(
begin_time >= @a
AND begin_time <= @b
)
OR (
begin_time <= @a
AND end_time >= @b
)
OR (
end_time >= @a
AND end_time <= @b