MySQL help needed

Hey Imaginary readers,

Is there anyone out there who could help me implement a pHpMyAdmin query? Ever since figuring out how to set it up so that WordPress holds spam comments in moderation without notifying me at all, I’ve been a little delinquent about deleting spam comments from this blog. There are now around 25,000 of them, which is too many to delete using the normal interface. A WordPress help search yields the result that I need to enter the following query into my MySQL database:

DELETE FROM wp_comments WHERE comment_approved='0'

However, I’m not too familiar with phpMyAdmin, or MySQL in general, and even though I think I found the database and entered this into the query box, it doesn’t seem to be working. I could use any remote tech support that the blogosphere has to offer. I can always just contact my pal who helped me set up my blog in the first place, hehe, but I thought I’d try and be self-sufficient. And, ah, by that I mean, begging anonymously for help instead of targetedly. And, ah, he’ll probably just read this anyway. Dammit.

Worth a shot, though. Anyone?

Leave a comment

Your email address will not be published. Required fields are marked *