Show only record of last week

[joane1]

Hi

I have some records, and I want to extract in my web page, only the records not oldest of 7 days.

How can I do the query?

[Kudose]

SELECT * FROM table WHERE DATE_SUB(NOW(), INTERVAL 7 DAY);

[bradgrafelman]

Probably need to add a date field in there...

SELECT column1, column2 FROM table WHERE DATE_SUB(NOW(), INTERVAL 7 DAY) <= date_column

Actually, this same query is listed on the MySQL manual page for Date and Time Functions (it's the very first sample query of the entire page).

[Kudose]

Yeah ... you probably will need a date column in there. :o