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:

Code:
select
schedule_id
from table
where
$start >= table.start and $end <= table.end and $day = table.day
I wouldn't be surprised if I'm way off.