Skip to content

Instantly share code, notes, and snippets.

@dianabotean

dianabotean/customer_entity_anonymize.sql

Created June 19, 2020 12:42
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dianabotean/f86e082b7c40ece51efdd1c0d4ae50f2 to your computer and use it in GitHub Desktop.
Save dianabotean/f86e082b7c40ece51efdd1c0d4ae50f2 to your computer and use it in GitHub Desktop.
Download ZIP
Anonymize customer email address
Raw
customer_entity_anonymize.sql
update customer_entity set email = (select concat(left(uuid(), 8), '@fakeaddress.com'));
@dianabotean
Copy link
Author

what does this do? it turns an address like 'diana.botean@yahoo.fr' into '12fbd7ee@fakeaddress.com'.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment