Given a range of dates, how to capture rows that has at least one of those dates in another range of dates?
Are there any MySQL functions to get all rows with with a start or end date that fall between a given start and end date?