How to replace parts of a text field using SQL in MySQL
Posted: Tue Jun 29, 2010 8:40 am
Code: Select all
UPDATE table_name SET field_name=REPLACE(field_name, 'old text', 'new text');
Code: Select all
UPDATE table_name SET field_name=REPLACE(field_name, 'old text', 'new text');