How to export the email addresses from a particular membergroup?

[aksal]

What query do I want to run to export the email addresses from a particular membergroup?
I use SMF 2.0.15
Thank you.

[Oldiesmann]

There is no built-in functionality to do this in SMF.

[vbgamer45]

You would need to run an sql query via phpmyadmin or another tool from the smf_members table where id_group = group id you need

[Illori]

what is the reason you want to export their email addresses? if it is to send an email to them you can do that using the newsletter function.

[aksal]

what is the reason you want to export their email addresses? if it is to send an email to them you can do that using the newsletter function.

It takes like forever if I use the build in Newsletter function because I have a lot of users. That's why I need to export the addresses and use an external tool for sending emails.

[aksal]

You would need to run an sql query via phpmyadmin or another tool from the smf_members table where id_group = group id you need

What would be the right query for this?
Thanks

[vbgamer45]

select email_address from smf_members where id_group = ###
### replace with group id

[Oldiesmann]

Might want to change that last part to "id_group = ### OR FIND_IN_SET(###, additional_groups)" to catch any members who are in that group but don't have it as their primary group.

[aksal]

select email_address from smf_members where id_group = ###
### replace with group id

Code Select Expand


MySQL returned an empty result set (i.e. zero rows). (Query took 0.0005 seconds.)

[vbgamer45]

Do what  Oldiesmann suggested above them in addition

[aksal]

Thank you guys, but still nothing.
I tried with

Code Select Expand

select email_address from smf_members where id_group = 7 OR FIND_IN_SET(7, additional_groups)
And with

Code Select Expand

select email_address from smf_members where id_group = 7 OR FIND_IN_SET(4, additional_groups)
and I get this again and again

Code Select Expand

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0431 seconds.)

[Sir Osis of Liver]

You'll get an empty result if id_group is not a valid membergroup.

[Arantor]

And those ids look like post count groups... are they post count groups?

[Biology Forums]

Posting just to bookmark the topic. Good question and great answers!

[aksal]

And those ids look like post count groups... are they post count groups?

Yes, post count groups.

[Arantor]

Would have been nice to know this, since not knowing this wasted everyone's time thus far.

select email_address from smf_members where id_post_group = 7

[m4z]

How/why should a user  or casual admin know there's a difference between postcount-based and normal groups?

[Arantor]

Because they don't act like other groups. Also, it's just courteous to provide as much information up front rather than having to pull it out later.

[aksal]

Would have been nice to know this, since not knowing this wasted everyone's time thus far.

select email_address from smf_members where id_post_group = 7

It worked perfectly now. Thank you very much.