Skip to content

Instantly share code, notes, and snippets.

@KangYoosam

KangYoosam/gist:e6cc36e0461b37e33f65e7d7df0e2128

Created June 11, 2018 13:20
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 KangYoosam/e6cc36e0461b37e33f65e7d7df0e2128 to your computer and use it in GitHub Desktop.
Save KangYoosam/e6cc36e0461b37e33f65e7d7df0e2128 to your computer and use it in GitHub Desktop.
Download ZIP
mask email on mysql
Raw
gistfile1.txt
update user set email = replace(email, left(email, instr(email, '@')-1),concat('xxxxxxx_', id));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment