Scramble emails in test Magento DB

scramble-magento-emails.sql

-- mladen@stuntcoders.com -> mladen@example.com
UPDATE `customer_entity` SET `email` = REPLACE(`email`, SUBSTRING(`email`, INSTR(`email`, '@') + 1), 'example.com');
UPDATE `sales_flat_quote_address` SET `email` = REPLACE(`email`, SUBSTRING(`email`, INSTR(`email`, '@') + 1), 'example.com');
UPDATE `sales_flat_order_address` SET `email` = REPLACE(`email`, SUBSTRING(`email`, INSTR(`email`, '@') + 1), 'example.com');

In case if you get a Duplicate Entry error, you can use it like
UPDATE customer_entitySETemail = REPLACE(email, SUBSTRING(email, INSTR(email, '@') + 1), CONCAT('example', entity_id, '.com'));