Skip to content

Instantly share code, notes, and snippets.

@Inggo-inHomePortal

Inggo-inHomePortal/get-wp-admins.sql

Created October 26, 2015 03:21
Show Gist options
  • Save Inggo-inHomePortal/ddd0a84a0bd96d715d90 to your computer and use it in GitHub Desktop.
Save Inggo-inHomePortal/ddd0a84a0bd96d715d90 to your computer and use it in GitHub Desktop.
Download ZIP
Get all WordPress admins via MySQL
Raw
get-wp-admins.sql
SELECT * FROM `wp_usermeta` LEFT JOIN `wp_users` ON `wp_usermeta`.`user_id` = `wp_users`.`ID` WHERE `meta_key` = 'wp_capabilities' AND `meta_value` LIKE '%administrator%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment