Replace () in MySQL to replace strings in MySQL.

How to replace strings in MySQL:

The replace function in MySQL directly replaces a specific string in a field in the MySQL database. It is very convenient to use instead of writing a function. Replace ()

Update 'table _ name' set 'field _ name' = Replace ('field _ name', 'From _ str', 'to _ str ') where 'field _ name' like '% from_str %'

Note:
Table_name -- table name
Field_name -- field name
From_str -- string to be replaced
To_str -- string to be replaced

For example:
Mysql> select Replace ('www .k686.com ', 'www', 'HTTP: // www ');
-> 'HTTP: // www.k686.com'

This function is multi-byte secure, meaning you do not need to consider Chinese or English characters.