così va?

Select * from ping where url='$url1' and (MID(orario,12,2)>7 AND MID(orario,12,2)<17)