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.