Just a quick code snippet that returns all rows whose date field is older than two days ago:
SELECT * FROM tablename WHERE datecolumn < DATE_SUB(CURDATE(); INTERVAL 2 DAY)
Who?
This is the blog of Ed van Beinum, a London-based open-source web developer. This blog is mostly a collection of notes-to-self and some useful links. They are made public in the hope that someone else may find them useful.
And it is pronounced "van Bay-num".