Delete after 2 days ?

[EchoFool]

Hey,

 

I need help on how i would get a query to delete rows of data where by field 1 or field 2 (timestamp format) is set to a timestamp of 2 days or older and delete them.

 

 

My current method is to loop all rows but thats not wise with more rows added so i need a new method. The timestamp format is:

YYYY-MM-DD HH:MM:SS

 

Hope you can help me.

[Maq]

You can accomplish this with DATE_SUB().

[EchoFool]

So:

 

DELETE FROM table WHERE DATE_SUB(Field, NOW()) > 1;

 

Would that compare the field to now as how many days has passed from the timestamp in the database?

[Maq]

Something like this:

 

DELETE FROM table WHERE field 
 

Any record where 'field' is more than 2 days old will be deleted.