How to change someone's email id using database query

  • Resolved Rajesh Namase

    (@namaserajesh)


    11 years, 5 months 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.

Viewing 1 replies (of 1 total)
  • Thread Starter Rajesh Namase

    (@namaserajesh)

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