Skip to content

Instantly share code, notes, and snippets.

@timwco

timwco/remove_post_by_author.sql

Created April 21, 2012 15:12
Show Gist options
  • Save timwco/2437665 to your computer and use it in GitHub Desktop.
Save timwco/2437665 to your computer and use it in GitHub Desktop.
Download ZIP
Remove All Post & Post Meta By Author - WordPress
Raw
remove_post_by_author.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_author = '0';
@timwco
Copy link
Author

timwco commented Apr 21, 2012

Just change '0' to the author ID

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment