Skip to content

Instantly share code, notes, and snippets.

@e10a

e10a/update-user-email

Last active March 31, 2022 18:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save e10a/1c074b25b8beb69054fa9bd28d3f6c6e to your computer and use it in GitHub Desktop.
Save e10a/1c074b25b8beb69054fa9bd28d3f6c6e to your computer and use it in GitHub Desktop.
Download ZIP
Update user email
Raw
update-user-email
UPDATE users
SET email=CONCAT('test+', id, '_', REPLACE(email, SUBSTR(email,INSTR(email,'@')+1),'amava.com'))
WHERE email NOT LIKE '%@amava.com';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment