Skip to content

Instantly share code, notes, and snippets.

@petrusnog

petrusnog/get_user_by_meta.sql

Created August 9, 2021 19:46
Show Gist options
  • Save petrusnog/6a304c75273bfdf5754d90377fd0be7b to your computer and use it in GitHub Desktop.
Save petrusnog/6a304c75273bfdf5754d90377fd0be7b to your computer and use it in GitHub Desktop.
Download ZIP
SQL that filters users by some metadata existance.
Raw
get_user_by_meta.sql
SELECT u.ID, u.user_login, u.user_nicename, u.user_email
FROM wp_users u
INNER JOIN wp_usermeta m ON m.user_id = u.ID
WHERE m.meta_key = 'billing_rg'!='';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment