Delete all users with Editor role and their content mysql

It’s a three step process.

  1. First, get a list of Editors using WP_User_Query.

  2. Get a list of each user’s posts using get_posts and delete them using wp_delete_post.

  3. Lastly, delete the user itself using wp_delete_user.

Related Posts:

  1. Automatically delete inactive users after 2 months
  2. Delete all subscribers from wp_users and wp_usermeta a few thousand at a time
  3. ‘username_exists’ still returns an ID even after deleting record from the database?
  4. How can I add a user through SQL?
  5. importing users where password is provided as md5 + much metadata
  6. Search multiple meta keys at once
  7. Return ID of authors who have at least one post
  8. How to delete users with no order history through phpmyadmin sql?
  9. wp_insert_user is not working for me?
  10. Set Display Name to first and last name (phpmyadmin SQL Query)
  11. Add user data to table when user is created?
  12. Bulk create clean user_nicename from user_email with SQL function
  13. C# user_nicename and Display name blank
  14. How do I transfer user passwords from one WordPress site to another?
  15. I am getting mysql_real_escape_string() function error while adding user?
  16. MySQL query to mass change role of users
  17. WordPress SQL Issue not returning correct reselts
  18. create new users in db starting at what ID?
  19. Delete Users without a First and Last Name
  20. How do I change the user via SQL?
  21. is_user_logged_in() not working after domain change
  22. MySQL query to list users who never signed in
  23. Forbidden :You don’t have permission to access /phpmyadmin on this server
  24. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  25. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  26. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  27. Confirmation required on email change
  28. Email user when password is reset by admin
  29. How to work around “that email address has already been used” error?
  30. How can I run a WP-CLI command as authenticated user?
  31. LEFT JOIN, INNER OUTER JOIN, LEFT OUTER JOIN is driving me crazy. Please help?
  32. Upload gravatar in WP profile?
  33. Recover the user that have been deleted
  34. Check if user is online?
  35. How to check that if current user (ID) has posts or not
  36. How to track a users progress through pages by inserting data into WordPress Database?
  37. How to get the Role Name of the current user? (WordPress)
  38. how to get recent registered author id?
  39. Is it possible to duplicate users on a new WordPress install?
  40. Why don’t first_name and last_name appear when you print_r the WP_User object?
  41. How to use search_columns in WP_User_Query?
  42. How to delete posts that does not have a thumbnail?
  43. Authenticate with a Rails app?
  44. Send Email to Users after Deleting Account
  45. How to add local users to wordpress without email password?
  46. WP User Query fails when searching meta queries and search columns
  47. Call to undefined function wp_insert_user()
  48. Update slug (URL) of pending posts via phpMyAdmin
  49. *wpupdateuser* user_login in my WordPress database
  50. Updating user meta
  51. Changing a username
  52. Change the user_login at registration
  53. How to add a user profile page to frontend?
  54. Error: How to allow the “contributor” to upload media in wordpress
  55. Delete users from multisite after they have not logged in for a set amount of time?
  56. Where is the information about the authors for articles stored?
  57. User management system similar to wordpress one?
  58. Restrict access of admin uploads to certain logged-in users?
  59. how to know when the user is in specific part of the website and when he leaves that part and display the data in the admin dashboard
  60. Find user by nicename and open profile
  61. Custom default filtering in the user admin panel disables the other sortable columns
  62. Creating user without username and password
  63. Is this code true or not
  64. Check for valid email after user inactivity?
  65. Better ads plugin has 500.000 entries in wp_postmeta
  66. How do I let contributors edit their posts after being approved once?
  67. Custom Comment Notifications Fire on each Page Load
  68. The Simple and Correct Way to Add User Meta
  69. how to set default update_user_meta values wordpress
  70. Fix ‘Add Role’ Option not there in wordpress 5.2.2
  71. Redirect user to login if not logged in, on specific pages
  72. Need to change all links in page content but not in post content
  73. Check if user is logged in via JS? [duplicate]
  74. Files on Localhost, Database on Server
  75. Page for logged in user to Edit/Delete their own content?
  76. Using mysql to replace img src?
  77. Followers for WordPress [duplicate]
  78. Is it possible to build social networking website using WordPress?
  79. DB prefix not updating
  80. Is there a way to call via javascript if a user is logged-in on a static html file?
  81. Restricting wordpress login sessions for a web app
  82. change user password REST API
  83. Use WP cookie to authentificate user on an external app
  84. Find count of WordPress users by role and search string for user name
  85. Append USER ID to an outbound link?
  86. SQL query to change custom field in WordPress database
  87. Users activity history
  88. How to destroy all user sessions via WP-CLI
  89. Is a list of user names or IDs in a custom profile field the best way to create a followers list?
  90. Get the author registration date in the header.php file
  91. Front end login and page restriction
  92. Designing a member area on my site
  93. Link to Authors blog posts
  94. view and update form only for registered users
  95. Redirect based on log-in status per JavaScript
  96. i need to let a user to add a role from a frontend form
  97. Integrating Facebook Registration (and Login) on a WordPress page
  98. Create users from frontend without password
  99. How to get user contact info
  100. Why does a super admin on multi site get a rest_user_invalid_id error code when requesting user details through REST?