Here is an example that uses date functions. The following query selects all rows with a
date_col value from within the last 30 days:
WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <=
The query also selects rows with dates that lie in the future.
And try also that
SELECT * FROM
> ‘2013/07/03’ order by