my sql find and replace code example

Example: find and replace database table phpmyadmin

update TABLE_NAME set FIELD_NAME =
replace(FIELD_NAME, 'Text to find', 'text to replace with');