MySQL replace statement

How can I search and replace within MySQL/MariaDB?

UPDATE table_name
SET table_field = REPLACE(table_field, 'find this string', 'replace with this string')
WHERE table_field LIKE '%find this string%'