mysql replace piece of a string for some entries

Question

I have a table "mytable" with a field "name" of varchar. I need to replace the string "iphone" in each string to "blackberry" how can I do that in one go?

Answer 1

MySQL String Functions

UPDATE mytable
SET name = REPLACE(name, 'iphone', 'blackberry')