How to find time range in mysql table with same day

[israellaky]

I have a time string as 8:00AM-9:30AM TTH stored in mysql table. I want to check time range, if user selected 9:00am-10:30am Thursday comes in between time 8:00AM -9:30PM? How to trap it out in php.

Time is stored as below

Time Day
8:00AM -9:30AM TTH
10:30AM -12:00PM
8:00AM -9:30PM
8:00AM -9:30PM

[israellaky]

I have a time stored in table 8:00AM-9:30AM TTH . I want to check time range, if user selected 9:00am-10:30am Thursday comes in between time 8:00AM -9:30PM? How to trap it out in php.

Time is stored in table as below

Time Day
8:00AM -9:30AM TTH
10:30AM -12:00PM MW
1:00PM -2:30PM MW
10:30AM -12:00PM FW

help me please this is my one of my error trap in my thesis project

thank you in advance