[resolved] Delete/change all comments by specific commenter (4 posts)

  1. MXJ
    Posted 7 years ago #

    For privacy/security reasons I have to either change the name of a specific commenter displayed in all of his comments or delete all of his comments. The first option would be preferable. Is there any way to do either of these without manually messing with the database?

  2. sarmadhassan
    Posted 7 years ago #

    I dont think so theres such feature or plugin available.. since i suppose you are an admin.. so change the password and be that user whos comments you wanna edit.. then use;


    i never came across such need neither i tried.. just suggesting a way.. hope it comes down good !

  3. Darran
    Posted 7 years ago #

    You can use a SQL statement to achieve this, it would seem a little technical though so please bear with me.

    Open your phpMyAdmin > select your database > SQL

    Assuming that your table names are using the default prefix:

    UPDATE comments
    SET comment_author = 'newname'
    WHERE comment_author LIKE 'originalname%'

    Hope this helps.

  4. MXJ
    Posted 7 years ago #

    sarmadhassan, thank you for the suggestion, but I just tried what Darran said and it worked perfectly well (I had to make the first line "UPDATE wp_comments" though). Thanks a lot!

Topic Closed

This topic has been closed to new replies.

About this Topic