dillonhafer/sanitize_emails.sql

Created June 9, 2022 13:10

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/dillonhafer/ffd0516419a900fc33c54ee02e3e48a6.js"></script>
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