Example Replace Statement in MySQL

Example Replace statement using UPDATE function MySQL for “find and replace” in MySQL.

update TABLE_NAME set FIELD_NAME = 
REPLACE(FIELD_NAME, ‘find this string’, ‘replace found string with this string’);