— 1st example
UPDATE files SET filepath = REPLACE(filepath,’path/to/search’,’path/to/replace’);

— 2nd example
UPDATE customers SET address = REPLACE(address,’_CODE_’,postcode);

Leave a Reply

Your email address will not be published. Required fields are marked *