Quote:
|
Originally Posted by Danielle
Anyone know how to do this in mySQL?
I have a table with a datetime column and need to delete all entries that are older than 15 days.
Hugs,
Danielle
|
to view the data:
select * from tablename where datetime < DATE_ADD(now(), interval -15 day) order by datetime;
and if it looks right, to delete:
delete from tablename where datetime < DATE_ADD(now(), interval -15 day);