Support » Fixing WordPress » Delete/change all comments by specific commenter

  • Resolved MXJ

    (@mxj)


    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?

Viewing 3 replies - 1 through 3 (of 3 total)
  • 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;

    http://wordpress.org/extend/plugins/edit-comments-xt/

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

    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.

    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!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Delete/change all comments by specific commenter’ is closed to new replies.