PetrovStark/get_user_by_meta.sql

Created August 9, 2021 19:46

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/PetrovStark/6a304c75273bfdf5754d90377fd0be7b.js"></script>
Save PetrovStark/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