#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.