如何查询此列，以便仅采用上周内的条目

Question

I have column called 'last updated' of this format: 2009-10-13 09:20:30 and I want to select all entries in the column that have a date that is within the last 7 days of the time the query is ran. I am using php in the backend for this query along with mysql.

I am constructing a large query, this will be part of it.

Thanks very much if you can help me.

Answer 1

A short example on how to do this:

SELECT *
FROM yourtable AS t1
WHERE t1.last_updated > DATE_SUB(NOW(), INTERVAL 7 DAY);

The documentation can be found here in the MySQL manual.