Skip to content

Instantly share code, notes, and snippets.

@dillonhafer

dillonhafer/sanitize_emails.sql

Created June 9, 2022 13:10
Show Gist options
  • Save dillonhafer/ffd0516419a900fc33c54ee02e3e48a6 to your computer and use it in GitHub Desktop.
Save dillonhafer/ffd0516419a900fc33c54ee02e3e48a6 to your computer and use it in GitHub Desktop.
Download ZIP
Sanitize emails in mysql
Raw
sanitize_emails.sql
update users
set email = replace(
email,
substring(
email,
locate('@', email),
length(email) - locate(email, '@')
),
'@example.com'
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment