判断时间重叠/重合

https://www.flipflops.org/2008/05/01/finding-overlapping-dates-and-times-in-mysql/

(输入开始值, 输入结束值)

... where 结束值字段 > 输入开始值 and 开始值字段 < 输入结束值

如:

输入(100, 200)
数据库 (start, end), (200, 300),(500, 600),(601, 700)

... where end > 100 and start < 200