Today I needed to update around 50 mysql entries containing emails since my customers domain just changed, here is how I did it :

UPDATE table SET email=REPLACE(email,"olddomain.com","newdomain.ca") WHERE customer="customer1";