mysql查询两个时间段是否有交集

https://wenku.baidu.com/view/fddc3b11ed06eff9aef8941ea76e58fafab04511.html

 

and ((a.`leave_start_date` >= #{dateStart} and a.`leave_start_date` <= #{dateEnd})
or (a.`leave_end_date` >= #{dateStart} and a.`leave_end_date` <= #{dateEnd})
or (a.`leave_start_date` <=#{dateStart} and a.`leave_end_date` > #{dateEnd})
)