How to compare date() in mysql query?

Question

In mysql date is formated as yyyy-mm-dd. I would to retrieve all related posts that is more then 25 days old.

Something like this:

SELECT * FROM post WHERE writtenday >= 25;

Many thanks

Answer 1

SELECT * FROM post WHERE DATEDIFF(CURDATE(), writtenday) >= 25;

Answer 2

You can use the DATE_SUB function

WHERE writtenday <= DATE_SUB(NOW(), INTERVAL 25 DAY)

This will retrieve anything that is older than TODAY-25 Days