check for between dates

[webgodjj]

I have two columns, Start_Date and End_Date in a table. I need to do a query to see if today is between them....

Is this the way to go about it?

select * from coupon where DATE() >= Start_DATE and DATE() <= End_Date;

[guelphdad]

change DATE() to CURDATE()

[r937]

... or better yet, CURRENT_DATE