selecting current match from the cricket schedule using mysql query
I have a cricket schedule and i need to select the matches of the current day just half an hour before the match starts and the selection should last until the 2 hours past the end of the match , this should be done in a single query i have used the following query but it is not working accurately...


SELECT * FROM `schedule` WHERE  date1  BETWEEN DATE_SUB(NOW(), INTERVAL 30 MInute) AND DATE_ADD(NOW(), INTERVAL 10 HOUR)


selecting current match from the cricket schedule using mysql query
===

I have a cricket schedule and i need to select the matches of the current day just half an hour before the match starts and the selection should last until the 2 hours past the end of the match , this should be done in a single query i have used the following query but it is not working accurately...


SELECT * FROM `schedule` WHERE  date1  BETWEEN DATE_SUB(NOW(), INTERVAL 30 MInute) AND DATE_ADD(NOW(), INTERVAL 10 HOUR)

