SQL Query to List WordPress administrator Account Names
The SQL for selecting a list of WordPress users with the role of “administrator”: SELECT um.user_id AS ID, u.user_login FROM wp_users u, wp_usermeta um WHERE u.ID = um.user_id AND um.meta_key = ‘wp_capabilities’ AND um.meta_value LIKE ‘%administrator%’ ORDER BY um.user_id Simply … Read More