Extracting E-Mails From DB?

I have a large amount of usertables that I extracted from my forum databases. I'm looking to extract all the emails from these databases as there are over 20k, what is the easiest way of doing this?

Also, does anyone know an efficient mass mailer for advertising?

 

If these emails do not have unsubscribe or were opt-in, you are in violation of the CAN-SPAM laws and will be charged $1 per message if you were brought to court for civil fines.

 

i can exract them for u for a nominal fee. PM me if interested.

 

You can easily extract them by issuing a simple SQL query:

You need to edit the query to make sure you have proper entries for user tables and email column

Hope this helps

 

Thanks for this, I don't agree with spamming though.

 

By SQL query.