How to delete all comments at once? (3 posts)

  1. HaloWebDesign
    Posted 4 years ago #

    Hi there.

    I have just found out that the blog I have set up to for personal use has received over 3,000 spam comments. I didn't realize people could do this if there is no way of joining the blog.

    Is there a quick and easy way to delete all these comments? I have no wish to allow any comments on this blog.

    Any advice is much appreciated.

  2. DharmShila
    Posted 4 years ago #

  3. adpawl
    Posted 4 years ago #

    Or dirrectly on database using sql query:
    only unapproved
    DELETE FROM wp_comments WHERE comment_approved = '0';
    or all
    DELETE FROM wp_comments;

Topic Closed

This topic has been closed to new replies.

About this Topic