Find and Replace text in Column value
The below example shows the find and replace text in column values in MySQL tables.
Syntax :
UPDATE `<Table Name>` SET `<Field Name>` = replace(fieldName, FIND_TEXT, REPLACE_TEXT)
Example :
UPDATE `Employee` SET `allImageURLsMobile` = replace(allImageURLsMobile, ‘/ids/’, ‘/ids/mobile/’)