MySQL replacement replace () implement MySQL replacement string

The code is as follows	Copy Code
Update ' table_name ' SET ' field_name ' = replace (' Field_name ', ' from_str ', ' to_str ') Where ' field_name ' like '%from_str% '

Description

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

Example

MySQL Replace substitution function syntax:

The code is as follows	Copy Code
UPDATE table_name SET field_name = replace (Field_name, "Find this string", "Replace found string with this string");

Replace substitution function Case:

The code is as follows	Copy Code
Update client_table Set url = replace (URL, "111cn.net", www.111cn.net)

This will replace all the strings in MySQL with the new ones.

Example 2

code is as follows

copy code

Example: update  ' dede_addonarticle '   SET body =  REPLACE (body,< br>   ' </td> ',   '); update  ' dede_addonarticle '   SET body =  REPLACE (body,   ' </tr> ',   '); update  ' dede_addonarticle '   SET body =  REPLACE (body,   ' <tr> ',   ');  &nb sp;     update  ' dede_archives '   SET title=  REPLACE (title,   ' Oceanic News-' ,   ');  update  ' dede_addonarticle '   SET body =  REPLACE (body,   ' ... /.. /.. /.. /.. /.. /',   ' http://special.fsaf/meal/');