MySQL fetches rows older than a week

Question

MySQL, how can I only select rows that are older than a week?

I need to do this in order to create a system that deletes the old tmp files that I have saved in the database.

+3

Jackie honson 09 Feb 13 at 11:43

3 answers

select * from table
where (SELECT DATEDIFF(curtime(),col_name)) > 7

+2

duffy356 09 Feb 13 at 11:49

SELECT * FROM `table` WHERE `created` < dateadd(week,-1,getdate())

+2

Andrei Zhamoida 09 Feb At 11:50 am

Orangecrush · Accepted Answer · 2013-02-09T11:53:25+0000

Try it,

select * from table
where DATEDIFF(now(),colname) > 7;