SELECT STATEMENT PROBLEM!

[Blood22]

The table I am using is titled : Booking table.

It consists of the following fields:

bookingid
userid
planereg
starttime
endtime

I am trying to produce a SELECT statement that will
SELECT * FROM booking WHERE
planereg = "Cessna 150" AND
starttime = "10:00:00" AND

So far so good everything is fine!

I don't know how to add in * IF starttime is less than 10:00:00 AND endtime is greater than 10:00:00 with the same booking id THEN do something...

Does anyone know how to phrase this mammoth statement!!!

Pleeeese help me!

Thanks

Si22.