mysql判断时间段是否重合

mysql判断时间段是否重合

SELECT CASE WHEN t1.start_time <= t2.end_time AND t1.end_time >= t2.start_time THEN ‘重合’ ELSE ‘不重合’ END AS result

FROM table_name t1, table_name t2

WHERE t1.id <> t2.id;