Skip to content

Instantly share code, notes, and snippets.

@felipeelia

felipeelia/wordpress-bulk-posts-delete-by-post-type.sql

Created October 26, 2017 21:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save felipeelia/cd9142c3ce7e9eb89f44e4cdd6883c41 to your computer and use it in GitHub Desktop.
Save felipeelia/cd9142c3ce7e9eb89f44e4cdd6883c41 to your computer and use it in GitHub Desktop.
Download ZIP
Delete ALL Posts, Meta and Terms Relationship of a Certain Post Type (Use With Caution)
Raw
wordpress-bulk-posts-delete-by-post-type.sql
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 = '<POST_TYPE>'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment