I have a table with data that has expiration date in the following format
0000-00-00.
I need to output the relsts that have expiration date today or later, but not anything that's before today
expiration >= CURDATE()
Not sure how to do that. I was thinking of splitting the date and then match like:
WHERE MONTH(expiration) >= ".$monthNow."
AND YEAR(expiration) >= ".$yearNow."
Something like that but this just does not seem right. There's got to be a better way. Can it be done from within MySQL query?
