How do I export all e-mail addresses from my database?

By HollywoodChicago.com on 12 Sep 2009 at 20:01 UTC

My site has been collecting e-mail addresses in two primary ways:

1) The e-mail address field when someone creates a new site account (required).
2) The e-mail address field when someone comments (required).

How can I export all of these e-mail addresses so I have one file of them all?

Comments

vm commented 12 September 2009 at 20:13

locate them in the database and use the export tools provided by your database management tool.

registration email addresses are stored in the users table I believe. I do not know where anon/comment email addresses are stored off hand.

HollywoodChicago.com commented 12 September 2009 at 21:11

Got the user account e-mails. Thanks! Anyone know in which table the comment e-mail addresses are stored?

P.S. For anyone else who wants to do this, the site user account e-mail addresses were in my database at users/mail.

johnhanley commented 13 September 2009 at 17:14

The table is aptly named comments; the column is mail. Put it together and you've got: comments.mail

HollywoodChicago.com commented 14 September 2009 at 16:54

Got those, too. You'd think I would have been able to figure that out, but thanks for your help! :-)