Find date between 2 date fields

Query to find the date exists between 2 date fields

SELECT *
FROM `hours_of_operation`
WHERE DATE( `schedule_start_date` ) <= '2011-07-06' AND DATE( `schedule_end_date` ) >= '2011-07-06'
LIMIT 0 , 30