SELECT * FROM booking
WHERE (booking_date_start BETWEEN '2018-07-10' and '2018-07-10')
and (booking_date_End BETWEEN '2018-07-10' and '2018-07-10')
and (booking_time_start BETWEEN '13:30:00' and '14:00:00' )
and (booking_time_end BETWEEN '13:30:00' and '14:00:00' ) WHERE `booking_room_id` ="4"
SELECT * FROM booking
where booking_date_start ='2018-07-10'
and booking_date_end ='2018-07-10'
and booking_time_start >='13:30:00'
and booking_time_end <='14:00:00'
WHERE booking_room_id = "4"
SELECT * FROM booking
WHERE (booking_date_start BETWEEN '2018-07-10' and '2018-07-10')
and (booking_date_End BETWEEN '2018-07-10' and '2018-07-10')
and (booking_time_start BETWEEN '13:30:00' and '14:00:00' )
and (booking_time_end BETWEEN '13:30:00' and '14:00:00' ) AND `booking_room_id` ="4"
SELECT * FROM booking
WHERE (booking_date_start BETWEEN '2018-07-10' and '2018-07-10')
and (booking_date_End BETWEEN '2018-07-10' and '2018-07-10')
and (booking_time_start BETWEEN '13:30:00' and '14:00:00' )
and (booking_time_end BETWEEN '13:30:00' and '14:00:00' ) AND `booking_room_id` ="4"
Load balance : Server 02
