Sometimes we are need friends email address to inform a good news, bad news, important information or anything but we had no time to collect their email address one by one. For blogger consumer of self hosting wordpress (free hosting or paid hosting) there is a quick way to get friends email address list who commented in our blog. There is the steps :

1. Logins to database via phpMyAdmin. At CPANEL, login to dashboard and search DATABASES tab  then click icon phpMyAdmin.

2. After open phpMyAdmin, click database wordpress intended. Remember, database who selected is which we would take the email data. If in one hosting there are multiple domain/blog, the database is also multiple. So doesn’t miscast .

3. Then would seems to enlisted table in the right side. Pays Attention To TABS is the top ( sees picture). There is tab structure, SQL, SEARCH, Query, etc. Please click tab SQL

4. At form RUN SQL QUERY please type query below then knob click GO

SELECT DISTINCT (comment_author_email),comment_author,comment_author_url
FROM `wp_comments`
GROUP BY comment_author_email

5. Hence coming up email list along with name and the URL. Then please click menu EXPORT. Part very under there are menu EXPORT (sees picture)

6. Last, please choose export result file tipes. Can be XLS, PDF, CSV, etc. Doesn’t forget to give sign at tab SAVE AS FILE is underside.

7. DONE , confuse ??? please left your questions in comment form below

Hopely Usefull and happy blogging

image from http://www.adelaidecomicsandbooks.com/images/e-mail-logo.jpg