Skip to content

Instantly share code, notes, and snippets.

@sidouglas

sidouglas/Delete WordPress Revisions by SQL

Created January 8, 2020 10:46
Show Gist options
  • Save sidouglas/aa8147bc49c17782cb136fd5bd714b6e to your computer and use it in GitHub Desktop.
Save sidouglas/aa8147bc49c17782cb136fd5bd714b6e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Delete WordPress Revisions by SQL
DELETE a,b,c FROM wp_posts a WHERE a.post_type = 'revision' LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment