Export a List of Commenter Email Addresses From Your WordPress Blog

This is a simple way to get a list of all of the email addresses of anyone who has commented on your WordPress blog. Open up phpMyAdmin and select your database. Then click on the Query tab and run this:

SELECT DISTINCT comment_author_email FROM wp_comments WHERE comment_approved = '1'

This will generate a list of all the emails addresses of commenters where the comment has been approved with no duplicates. Now you can click “Check All” and then “Export” under the query results operations section, as shown below:

You’ll be able to select from several different file types, including .csv, .doc, .pdf, .xml, and a few others.

Comments (1)

  1. Hi. Interesting trick. May you advice me how to perform the following operation? I move my old blog to wordpress but now most of commenters have no e-mail and no gravatar, only name and url. I know most of their e-mails, so I would like to use an SQL statement to associate the e-mail I know to the corresponding URL. But how? Thank you in advance.