Sanitize emails in db

drush sqlq "UPDATE users SET mail = concat('myaddr+', replace(mail, '@', '_'), '@testdomain.org') WHERE uid > 0 AND instr(mail, '@testdomain.org') = 0;" && drush upwd --password=password admin

Tags: