dianabotean/customer_entity_anonymize.sql

Created June 19, 2020 12:42

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

Select an option

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

Author

dianabotean commented Jun 19, 2020

what does this do? it turns an address like '[email protected]' into '[email protected]'.

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