Code: Select all
DELETE FROM samples WHERE status = 'added' AND DATEDIFF(now(),dateadded) > 14This just deleted ALL that were "added", and only went in today.
Moderator: General Moderators
Code: Select all
DELETE FROM samples WHERE status = 'added' AND DATEDIFF(now(),dateadded) > 14