Change WordPress user roles and capabilities › Forums › How to or FAQ › Invert View Filter › Reply To: Invert View Filter
06/04/2020 at 12:39
#6748
Vladimir
Keymaster
Hi Mike,
It’s not possible with UI at wp-admin. You may use any SQL tool, like phpMyAdmin or MySQL WorkBench, and execute this command:
SELECT DISTINCT wp_users.ID, wp_users.user_login, wp_usermeta.meta_value
FROM wp_usermeta
JOIN wp_users on wp_users.ID=wp_usermeta.user_id
WHERE wp_usermeta.meta_key='wp_capabilities' AND
wp_usermeta.meta_value NOT LIKE '%subscriber%'
ORDER BY wp_users.ID;
Just replace ‘wp_’ at the database tables names with your DB prefix from wp-config.php.
Make the same replacement for the meta_key ‘wp_capabilities’ value.
Command above will show the list of all users without subscriber role.