How to export emails of all the commentators on a WordPress blog

Emailing all your commentators is an amazing way to increase the reader base of your blog. Isn’t it? The chances are quite high that these commentators will come back to your blog since they have already commentated on it earlier. So, why not do then? In order to extract the emails of all your wordpress commentators without any duplicates,

Step 1:

Log in to phpMyAdmin from your cPanel.

Step 2:

On the utmost left side, you shall find a list of all the databases for each of your websites/blogs. Click the name of the database that from which you want to extract the emails. If you have more than one databases in the list and are not sure which one is for your website/blog, open your wp-config.php file and find it out.

Step 3:

On the next screen, click the ‘SQL’ tab.

Step 4:

Enter the following SQL query and click ‘Go’.

SELECT DISTINCT comment_author_email FROM wp_comments;

Important Note: If you have changed the prefix for your wordpress tables in wp-config.php under ‘$table_prefix‘, replace ‘wp’ in the below given query with the same. For instance, if the name of your table prefix is stjac891, your query will look like this:

SELECT DISTINCT comment_author_email FROM stjac891_comments;

Step 5:

Click ‘Export’ option available at the bottom.

Step 6:

Choose your desired output format and click ‘Go’.

Step 7:

This step is just to inform you that it’s done…