Skip to content

Instantly share code, notes, and snippets.

@trueqap

trueqap/mass_delete_users.sql

Last active November 12, 2018 19:03
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 trueqap/f1e52a5143549a516911b346f0356bf8 to your computer and use it in GitHub Desktop.
Save trueqap/f1e52a5143549a516911b346f0356bf8 to your computer and use it in GitHub Desktop.
Download ZIP
WordPress mass delete subscriber users
Raw
mass_delete_users.sql
delete wp_users, wp_usermeta
FROM wp_users INNER JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id
WHERE meta_key = 'wp_capabilities' AND meta_value LIKE '%subscriber%';
//cleaning:
DELETE wp_usermeta
FROM wp_usermeta LEFT JOIN wp_users ON wp_usermeta.user_id=wp_users.id
WHERE wp_users.id IS NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment