Mass Edit Comment Author via SQL

  • Resolved jbbaab44

    (@jbbaab44)


    13 years, 1 month ago

    I need a SQL guru to help me with a query on finding a comment author based on IP and changing the author name. So the logic is . .

    WHERE comment_author_IP = 123.123.1.1
    RENAME comment_author to John Doe

Viewing 1 replies (of 1 total)
  • Thread Starter jbbaab44

    (@jbbaab44)

    13 years, 1 month ago

    I figured it out

    UPDATE wp_comments SET comment_author = REPLACE( comment_author, ‘old comment author’, ‘new comment author’ ) WHERE comment_author_IP = 123.123.1.1 ;

Viewing 1 replies (of 1 total)

The topic ‘Mass Edit Comment Author via SQL’ is closed to new replies.