Skip to content

Instantly share code, notes, and snippets.

@osrecio

osrecio/SQL: Delete Post Revision WP

Last active December 14, 2015 08:19
Show Gist options
  • Save osrecio/5057005 to your computer and use it in GitHub Desktop.
Save osrecio/5057005 to your computer and use it in GitHub Desktop.
Download ZIP
Delete Post Revision Wordpress
Raw
SQL: Delete Post Revision WP
DELETE a.*,b.*,c.*
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = 'revision';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment