Mysql uses the replace command for batch replacement

Mysql uses the replace command to replace mysql> select * from test1 in batches; + ------ + --------- + www.2cto.com | id | name | + ------ + --------- + | 1 | aaaKaaa | 2 | bbbKbbb | 3 | cccKccc | + ------ + --------- + 3 rows in set (0.00 sec) mysql> update test1 set name = replace (name, 'k', '2017. 99.224.138 '); Query OK, 3 rows affected (0.01 sec) Rows matched: 3 Changed: 3 Warnings: 0 mysql> select * from test1; + ------ + ---------------------- + | id | name | + ------ + -------------------- + | 1 | bytes | 2 | average | 3 | average | + ------ + -------------------- + 3 rows in set (0.00 sec)