MySQL Replace function replacement string

SQL statement:

The code is as follows	Copy Code
UPDATE table_name Set Field_name=replace (field_name, ' from_str ', ' to_str ')

Description
table_name--the name of the table
field_name--Field Name
from_str--a string to replace
to_str--replaced with string

For example

Table: ABC
Fields: XXX
The changed string: a
Replaced by string: C

The code is as follows	Copy Code
Update ABC set Xxx=replace (XXX, ' A ', ' C ')

Cases

code is as follows	copy code
UPDATE   ' dede_addonarticle '   SET body =  REPLACE (body, ' </td> ', '); update  ' dede_addonarticle '   SET body =  REPLACE (body, ' </tr> ', '); update  ' dede_addonarticle '   SET body =  REPLACE (body, ' <tr> ', ');     & nbsp;  update  ' dede_archives '   SET title=  REPLACE (title, ' Oceanic News-', ');