Page 1 of 1
How do I delete where dateadded is 14 days old +
Posted: Wed Aug 27, 2014 6:15 am
by simonmlewis
Code: Select all
DELETE FROM samples WHERE status = 'added' AND DATEDIFF(now(),dateadded) > 14
Trying to run a little query that just deletes entries where the 'dateadded' is 14 days or more old.
This just deleted ALL that were "added", and only went in today.
Re: How do I delete where dateadded is 14 days old +
Posted: Wed Aug 27, 2014 6:26 am
by Celauran
Syntax looks correct and works as expected for me. dateadded is a DATE type column?
Re: How do I delete where dateadded is 14 days old +
Posted: Wed Aug 27, 2014 7:21 am
by simonmlewis
Yes it is. "date" is in the field type.
Re: How do I delete where dateadded is 14 days old +
Posted: Wed Aug 27, 2014 7:25 am
by simonmlewis
Sorry my bad, it is working.
Thanks anyway.