Snippet
Written with a loving hand by kitt some time around 16:42 on 12 October 2009
When you have live data in a testing database, you don't want to trigger emails that go to your users. In the case where you need the rest of the data, and need valid email addresses, append .example.com to turn current valid email addresses into syntactically valid email addresses, but not emailable addresses.
UPDATE`orders`SET email =CONCAT(email,'.example.com')WHERE email NOTLIKE'%example.com';-- alternately, to undo this change, use replaceUPDATE`orders`SET email =REPLACE(email,'.example.com','');