Skip to content

Instantly share code, notes, and snippets.

@izdrail
Created February 16, 2021 09:23
Show Gist options
  • Save izdrail/f229ee7a9be2a4d907e0005f04324f68 to your computer and use it in GitHub Desktop.
Save izdrail/f229ee7a9be2a4d907e0005f04324f68 to your computer and use it in GitHub Desktop.
Delete All Wordpress Posts Using 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 = '{{your CPT}}';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment