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!