I have a MySQL table with the following fields:
- name
- starttime
- endtime
starttime
and endtime
are MySQL TIME
fields (not DATETIME
). I need a way to periodically "scan" the table to see if there are any overlaps in time ranges within the table. If there is an event from 10:00-11:00
and another from 10:30-11:30
, I want to be alerted of the presence of the time overlap.
Nothing fancy really, all I want to know whether an overlap exists or not.
I'm going to be using PHP to execute this.
See Question&Answers more detail:os