The Support Forums will be in read-only mode for a scheduled maintenance window on 01 September 2016 14:00 UTC - 20:00 UTC. More information.

Approve Comments From a Specific Email Across Multiple Installations (1 post)

  1. Arun Basil Lal
    Posted 3 years ago #

    I have about 200 WordPress installs on a host. Recently, I noticed that some genuine comments from known sources are sent to spam. Sorting them out on a blog by blog basis is turning out to be a pain.

    Can someone suggest an SQL query that would look across all the databases on the server for comments from a particular email in spam and approve it?

    All databases are named in order starting from arunbasi_wrdp1 , arunbasi_wrdp2 and so on and have the table prefix as wp_

    Hope this is possible. Thanks.

Topic Closed

This topic has been closed to new replies.

About this Topic

  • RSS feed for this topic
  • Started 3 years ago by Arun Basil Lal
  • This topic is not resolved
  • WordPress version: 3.4.2