根据当前日期获得结果

Question

I have a table that is similar the one below. My goal is to only return the results which are the upcoming dates, not the only which were already past.

id    |   date
1       Mar 12 2012 
2       Apr 17 2013
3       Oct 22 2014
4       Jul 12 2015

Desire result:

id    |   date
1       Oct 22 2014
2       Jul 12 2015

I have tried doing the line below, but it is returning zero results.

SELECT * FROM `table` WHERE NOW() < `date`

OR

SELECT * FROM `table` WHERE `date` > CURDATE() ;

Answer 1

Well, being a bit straight, your data is a mess :)

Basically, you can't store dates in MySQL using that format. That results in the column being a (var)char. Trying to sort a string as if it was a datetime will not only bring you trouble (which it has actually started because you had to post a question here) but will also result in poor query performance.

You should absolutely reconsider changing that into a datetime.