The following code will replace a string in a database field
UPDATE `TableName`
SET `DatabaseField` = REPLACE(`DatabaseField`, 'OldString', 'NewString')
WHERE `DatabaseField` LIKE '%OldString%';
Disclaimer: The code on this website is provided "as is" and comes with no warranty. The author of this website does not accept any responsibility for issues arising from the use of code on this website. Before making any significant changes, ensure you take a backup of all files and do not work directly on a live/production website without thoughly testing your changes first.