Need Help With Getting Values from a Wordpress Database Table

PHP
1

Hi. I’m trying to list email values of users that have a certain common database value.

I have a wordpress membership site. On the registration form I’ve added a field called “Group Name”. In the “wp_usermeta” database table in the “meta_value” column it’s called “group_name”. In the “meta_key” column the value would be something like “Group A” which would be entered by the person registering.

So I want to list all user emails that have registered as “Group A”.

I’ve played with the SELECT * FROM wp_usermeta WHERE meta_value=‘Group A’ but I don’t know how to get and list the email addresses which are in the same “user_meta” table but under a row called “user_email”

Can someone help me please?

Thanks

2

Sorry - It should read -

I have a wordpress membership site. On the registration form I’ve added a field called “Group Name”. In the “wp_usermeta” database table in the “meta_key” column it’s called “group_name”. In the “meta_value” column the value would be something like “Group A” which would be entered by the person registering.