Approve Comments From a Specific Email Across Multiple Installations

  • 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.

  • The topic ‘Approve Comments From a Specific Email Across Multiple Installations’ is closed to new replies.