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
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