How to Extract commentators Email address with IP & Name from a post in WordPress [Featured]

by Mayur on August 22, 2010

in Blogging, How To's

WP If you’re a blog administrator who frequently organises giveaway and contest, then you’ll find this article really helpful. Making a comment by participants is necessary in most of the giveaways and it becomes really difficult for site admin to randomly draw the winners, if the comments are in large number.

An exclusive way is discovered by us which will allow you to extract the email addresses, IP address and Name of all commentators from a specific post in WordPress.org.

Follow the step by step tutorial below carefully to extract Email address:

1. Login to cPanel (of your blog host).

2. Go to phpMyAdmin under Databases section.

3. Select your blog database from the left panel which may be marked as _wrdp1

select your database

4. Click on wp_comments from table in left hand side.

click on wp_comments

5. Now click on “Search” tab.

6. Open Options (in blue), Select comment_author, comment_author_email and comment_author_ip in the fields box. Tick mark ‘DISTINCT’ to remove the exactly similar entries (those with same name, email and IP address).

set parameters in Search

7. Input comment_post_id = xxxx under "Add search conditions (body of the "where" clause):" Replace xxxx with the post ID.

To find Post ID of a post, just login to your blog’s WordPress dashboard. Open ‘Posts’ and point your mouse over the preferred post. You’ll then see a link in the status bar of browser. Just note the no. next to post=xxx (For eg: Here it is 7260) as shown below:

find post id

8. Set Number of rows per page to 1000

9. Display order Ascending

10. Click ‘GO’ button. All queries will be sorted now.

11. Click Export button, select ‘CSV for MS Excel’ and tick mark ‘Save as file’. Click GO.

choose export format

A MS Excel file will now be produced containing all the commentators name, IP and email address from a certain post. You can then find duplicate email and IP addresses and sort the invalid ones using Excel. Then you can copy all the email addresses and use Random.org to draw the giveaway winners.

This guide looks difficult in starting but you’ll find it really easy, once you get used to it. This post is specially for bloggers who conduct big giveaways on their blog. :D

Do share this tutorial if you find it useful.

Update – Sandip of BlogsDNA has provided us a source code which eliminates 6 steps and makes it real easy to do this task. :D Check below how to do it:

Go to phpMyAdmin and select your blog database. Now click on “SQL” tab. Input the below SQL query there and click the ‘Go’ button. You’ll now come straight to Step 11.

SELECT DISTINCT comment_author, comment_author_email, comment_author_IP
FROM (
SELECT DISTINCT comment_author, comment_author_email, comment_author_IP
FROM wp_comments
WHERE `comment_post_ID` = ‘xxxx’
) AS WEBTRICKZ

Remember to Replace xxxx with your Post ID.

Related Posts:

Liked this article? Then SUBSCRIBE to RSS Feed or get Free updates via E-MAIL



{ 10 comments… read them below or add one }

Rohit Langde August 22, 2010 at 12:24 pm

That’s good for someone geeky and used to phpmyadmin interface. As far as I remember, I used Contact Commentators plugin by Ajith Prasad Edassery http://wordpress.org/extend/plugins/contact-commenters/ which does the same thing easy way.

Reply

Avinash August 22, 2010 at 9:00 pm

That looks great but too technical for a simple guy. I use a much simpler method to extract email addresses from comments whenever I hold a contest. Even IP address and name is possible with that.

But still, phpmyadmin method good for anyone who is comfortable with using phpmyadmin. Good post. :)

Reply

Mayur August 22, 2010 at 9:53 pm

As I said, this process looks difficult but is really simple to use. BTW.. what simpler method do you use, any plugin?

Reply

Avinash August 22, 2010 at 10:03 pm

Its not a plugin, just a combination of notepad plus MS excel.

Reply

Raju August 22, 2010 at 10:53 pm

This is very useful and helpful, especially when there are hundreds of entries, wish you had written this last year :D

Reply

Mayur August 23, 2010 at 1:22 pm

Thanks Raju for appreciating it. Yes, it is very handy for big giveaways where there are numerous comments. :D

Reply

Sandip August 23, 2010 at 2:24 pm

Thanks Mayur,

lol Ok so it was good laugh for me to teas Mayur with “BLOGSDNA” watermark thingy but well You can replace BLOGSDNA from above query with any thing you like but it should read some thing like “AS XYZ”. :)

Reply

Mayur August 23, 2010 at 2:42 pm

Haha… so can I replace BLOGSDNA with WEBTRICKZ with your consent. :D

Reply

Sandip August 23, 2010 at 2:44 pm

Yeah go ahead. :)

Reply

panamalaw fraud April 21, 2012 at 3:07 am

Wonderful site. Lots of helpful info here. I am sending it to some pals ans also sharing in delicious. And certainly, thank you for your sweat!

Reply

Leave a Comment

{ 1 trackback }

Previous post:

Next post:

   Copyright © 2008-2014 WebTrickz | Google+ | Sitemap | Privacy Policy | Advertise | Back To Top