Time function puzzle

[rulian]

Okay, what I want to do is have mysql search 3 different tables and gather all the information that has been created or modified in the past 2 days, and post them in a table. is there a time function that I can use to make mysql search for files at max 2 days old and exclude all others over that limit?

[Anon]

yes you can...
read the manual? 🙂

it's called date_sub or something like that...
I can't remember it exacly... @home 🙂

Hope it helps, Arni

[sepodati]

SELECT * FROM table WHERE date_column > NOW() + INTERVAL 2 DAY

---John Holmes...