— 1st example
UPDATE files SET filepath = REPLACE(filepath,’path/to/search’,’path/to/replace’);
— 2nd example
UPDATE customers SET address = REPLACE(address,’_CODE_’,postcode);
— 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