[resolved] How to change someone's email id using database query (2 posts)

  1. Rajesh Namase
    Posted 3 years ago #

    I've switched my site from Namase.com to TechLila.com and added 301 redirection to Namase.com, I want to change email id in comments using Database query, old email id is rajesh [at] techlila.com and I want to change it into admin [at] techlila.com

    Changing the email id in profile not change the email id in old comments. Any help? Thanks in advance.

  2. Rajesh Namase
    Posted 3 years ago #

    Created code myself, WP having great codex part which is simply awesome :)

    UPDATE wp_comments
    SET comment_author_email =
    REPLACE(comment_author_email, 'rajesh@techlila.com', 'admin@techlila.com');

Topic Closed

This topic has been closed to new replies.

About this Topic