MySQL String replacement Brief introduction

Description

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

Example 1

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% '

Example 2

For example, you want to replace the ABC of the F1 field in the table TB1 with Def

The code is as follows	Copy Code
UPDATE tb1 SET f1=replace (F1, ' abc ', ' Def ');

Usage 1.

The code is as follows	Copy Code
Replace intoreplace into table (id,name) VALUES (' 1 ', ' AA '), (' 2 ', ' BB ')

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