MySQL | Find and Replace text in Column value

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/’)