Skip to content

Instantly share code, notes, and snippets.

@seemly

seemly/safe-delete-flamingo-inbound-messages-older-than-3-months.md

Last active June 5, 2024 13:59
Show Gist options
  • Save seemly/dc54abc0ec5bafe50174f975394912e5 to your computer and use it in GitHub Desktop.
Save seemly/dc54abc0ec5bafe50174f975394912e5 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL query to delete Flamingo WordPress plugin Inbound Messages created more than 3 months ago.
Raw
safe-delete-flamingo-inbound-messages-older-than-3-months.md 
START TRANSACTION;

DELETE FROM wp_posts
WHERE post_type = 'flamingo_inbound'
AND post_date < DATE_SUB(CURDATE(), INTERVAL 3 MONTH);

ROLLBACK;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment