How do I find all admin users using phpmyadmin?

 

SELECT wp_users.*

<?php

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 ASC

Ref: Link