Results 1 to 1 of 1
Thread: Checking for overlapping in time
Feb 28, 2005, 20:09 #1
- Join Date
- Jan 2004
- New York
- 0 Post(s)
- 0 Thread(s)
Checking for overlapping in time
I have a table with two time columns, 'start' and 'end' and an additional enum column that has the days monday, tuesday, etc.
Before I insert or edit an entry I want to make sure that the "timeslot" does not conflict with any other timeslot in this database.
Here is my mySQL.com documentation derived guess:
select schedule_id from table where$start >= table.start and $end <= table.end and $day = table.day