Skip to content

Instantly share code, notes, and snippets.

@filmgirl

filmgirl/delete-custom-post-type.sql

Created July 30, 2018 19:13
Show Gist options
  • Save filmgirl/c833c7a4433d1112111bb1fc5ebda5b0 to your computer and use it in GitHub Desktop.
Save filmgirl/c833c7a4433d1112111bb1fc5ebda5b0 to your computer and use it in GitHub Desktop.
Download ZIP
SQL query for efficiently deleting WordPress CPT
Raw
delete-custom-post-type.sql
DELETE FROM wp_posts
WHERE post_type = 'post_type';
DELETE FROM wp_postmeta
WHERE post_id NOT IN (
SELECT
id FROM wp_posts);
DELETE FROM wp_term_relationships
WHERE object_id NOT IN (
SELECT
id FROM wp_posts);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment