WordPress.org

Ready to get started?Download WordPress

Forums

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

  1. Arun Basil Lal
    Member
    Posted 1 year 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