Replace part of text in a column in MySql/MariaDB database

You can replace part of the text like that:

UPDATE Episodes  SET LocalFile = REPLACE(LocalFile, 'somethingOld', 'somethingNew')

Be carefull. It has no WHERE so will run on the whole table.