Replace text in field in MySQL database

SET SQL_SAFE_UPDATES = 0;

UPDATE database.table SET field = REPLACE(field, 'old text','new text');

SET SQL_SAFE_UPDATES = 1;