Check for between dates

webgodjj · January 25, 2011, 2:23am

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 · January 25, 2011, 3:57am

change DATE() to CURDATE()

r937 · January 25, 2011, 7:52am

… or better yet, CURRENT_DATE