How to replace parts of a text field using SQL in MySQL

[Saman]

Code: Select all

UPDATE table_name SET field_name=REPLACE(field_name, 'old text', 'new text');