Search and update / replace part of text with MySQL

Update / replace text with mysql.

UPDATE tbl_name
SET
    field_name = REPLACE(field_name,
        "string_to_find",
        "string_to_replace")
WHERE
    conditions;

where state can be optional.