Over the next few days we are going to start the migration to a new forum
application. I'm going to start with high post count and active users. You may
receive an invitation to the new forums. It's not spam. It's just me trying to
seed the user base. My goal is to open it up over the weekend.
Once we open the site we'll block registrations here. We should be open
shortly on the new site.
I have a customer who has NEVER moderated her comments. She has over 13,000 of them and 99.9% are spam.
I tried this:
SELECT FROM wp_comments WHERE comment_approved = 0 planning to delete once I had gotten them all.
But the error message I got was this:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM wp_comments WHERE comment_approved = 0 LIMIT 0, 30' at line 1
Please tell me what I am doing wrong.Thanks so much!