replace value on condition mysql code example

Example: mysql find and replace

UPDATE `table` SET `column` = replace(`column`, 'find text', 'replace text')