List of WordPress users without role

  • Sumo

Here is the SQL that will provide you the list of users that does not have role on your website.

Assuming you have banned some users, with assigning them No Role For this website.


SELECT user_id FROM `wp_usermeta` 
WHERE meta_key='wp_capabilities' 
AND meta_value='a:0:{}'


About the Author

Edgar Marukyan is an expert of website development and performance optimization, who maintains and consults clients with high load traffic websites.. If you need an assistance, feel free to drop me a line.         Website - Twitter - Facebook

Leave a Reply

If you want a picture to show with your comment, go get a Gravatar.