Skip to content

Instantly share code, notes, and snippets.

@misfist

misfist/delete-old-post.sql

Created February 14, 2018 19:39
Show Gist options
  • Save misfist/b15c394fa0a5629d14b2a5e1901438b2 to your computer and use it in GitHub Desktop.
Save misfist/b15c394fa0a5629d14b2a5e1901438b2 to your computer and use it in GitHub Desktop.
Download ZIP
Delete posts older than X days.
Raw
delete-old-post.sql
DELETE FROM wp_posts WHERE post_type = 'post' AND DATEDIFF(NOW(), post_date) > X;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment