MySQL Tutorial: Database character substitution and use of the Replace function

Sometimes you can use the Replace function when you want to replace the contents of a field in a database:

The syntax is as follows:

UPDATE tb1 SET f1=replace (F1, ' abc ', ' Def ');

REPLACE (STR,FROM_STR,TO_STR)

All occurrences of the string from_str in string str are replaced by TO_STR, which then returns the string:

Mysql>selectreplace (' www.mysql.com ', ' w ', ' Ww ');

-> ' WwWwWw.mysql.com '

This function is multibyte-safe.

Example:

UPDATE ' dede_addonarticle ' SET BODY = REPLACE (body,

' </td> ',

'' );

UPDATE ' dede_addonarticle ' SET BODY = REPLACE (body,

' </tr> ',

'' );

UPDATE ' dede_addonarticle ' SET BODY = REPLACE (body,

' <tr> ',

'' );

UPDATE ' dede_archives ' SET title= REPLACE (title,

' Oceanic News-',

'' );

UPDATE ' dede_addonarticle ' SET BODY = REPLACE (body,

'.. /.. /.. /.. /.. /.. /',

' http://special.dayoo.com/meal/');

MySQL Replace

Usage 1.replace intoreplace into table (id,name) VALUES (' 1 ', ' AA '), (' 2 ', ' BB ')

The purpose of this statement is to insert two records into table tables.

2.replace (object, Search,replace)

Replace all occurrences of search in object with Replaceselect replace (' www.bianceng.cn ', ' w ', ' Ww ')--->www wWw.bianceng.cn

For example: Replace AA in the Name field in table tables with Bbupdate table set Name=replace (name, ' AA ', ' BB ')