WordPress.org

Support

Support » How-To and Troubleshooting » [Resolved] How to change someone's email id using database query

[Resolved] How to change someone's email id using database query

  • 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.

Viewing 1 replies (of 1 total)
  • 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');
Viewing 1 replies (of 1 total)
  • The topic ‘[Resolved] How to change someone's email id using database query’ is closed to new replies.