webgodjj — 2011-01-24T21:23:39-05:00 — #1
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 — 2011-01-24T22:57:38-05:00 — #2
change DATE() to CURDATE()
r937 — 2011-01-25T02:52:22-05:00 — #3
... or better yet, CURRENT_DATE