select * from table 
where (start_time    between desired_start and desired_stop)
or    (end_time      between desired_start and desired_end)
or    (desired_start between start_time    and end_time)
or    (desired_stop  between start_time    and end_time)