How do I find all admin users using phpmyadmin?
We can generate the SQL with: $query = new WP_User_Query( [ ‘role’ => ‘Administrator’, ‘count_total’ => false, ] ); echo $query->request; that outputs: SELECT wp_users.* FROM wp_users INNER JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) WHERE 1=1 AND ( ( ( wp_usermeta.meta_key = ‘wp_capabilities’ AND wp_usermeta.meta_value LIKE ‘%\”Administrator\”%’ ) ) ) ORDER BY user_login … Read more