Skip to content

Instantly share code, notes, and snippets.

@utsukushiihime

utsukushiihime/wordpress-list-users.sql

Forked from petenelson/wordpress-list-users.sql
Created June 24, 2021 23:37
Show Gist options
  • Save utsukushiihime/05ff720ac3ac7269a087e647af004f2d to your computer and use it in GitHub Desktop.
Save utsukushiihime/05ff720ac3ac7269a087e647af004f2d to your computer and use it in GitHub Desktop.
Download ZIP
WordPress: MySQL query to list user names, emails, and first & last name
Raw
wordpress-list-users.sql
SELECT wp_users.user_login, wp_users.user_email, firstmeta.meta_value as first_name, lastmeta.meta_value as last_name FROM wp_users left join wp_usermeta as firstmeta on wp_users.ID = firstmeta.user_id and firstmeta.meta_key = 'first_name' left join wp_usermeta as lastmeta on wp_users.ID = lastmeta.user_id and lastmeta.meta_key = 'last_name'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment