Export/extract all the URLs of all the commenters

  • Resolved utnalove

    (@utnalove)


    13 years, 1 month ago

    Hello…

    I would like to have a list of all the URLs that have ever been added in the URL field of the comments.

    I need to check all those URLs one by one… avoiding to look into each comments, since I have thousands of comments and probably few tens of URLs.

    I hope you can help

Viewing 2 replies - 1 through 2 (of 2 total)

  • The easiest way would be to directly query your site’s database, either from the command line or from phpMyAdmin (or similar database management software):

    SELECT comment_ID, comment_author_url FROM wp_comments;

    Thread Starter utnalove

    (@utnalove)

    Wow… excellent!! Thank you soo much

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Export/extract all the URLs of all the commenters’ is closed to new replies.