Delete all users with Editor role and their content mysql

Question

I have a Wordpress site with thousands of editors. I cant delete them from the WP dashboard as its to slow.

I need a query to delete all the editor users and their posts from PhpMyAdmin?

Thanks

Answer 1

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.