mysql replace part of the field content and mysql replace function replace()

[mysql] replace usage (replace part of the content of a field)

[mysql] replace usage

1. replace into

replace into table (id,name) values('1','aa'),('2','bb')
The purpose of this statement is to insert two records into the table. If the primary key id is 1 or 2 and does not exist, it is equivalent to
insert into table (id,name) values('1','aa'),('2','bb')
If the same value exists, the data will not be inserted.

2.replace(object,search,replace)

Replace all occurrences of search in object with replace
select replace('www.163.com','w','Ww')--->WwWwWw.163.com
Example: Replace aa in the name field in the table table with bb
update table set name=replace(name,'aa','bb')

3.UPDATE updates part of the content in a field

Now there is a record with a field "abcdefg". Now I just want to change the c in the field to C. How should I write the update statement?

update table name set field1 = replace(field1,'c','C')

Knowledge point expansion:

mysql replace function replace() implements mysql to replace the string in the specified field

MySQL replace string implementation method:

The replace function in MySQL directly replaces a specific string in a field in the MySQL database. You no longer need to write your own function to replace it, which is very convenient to use. mysql replace function replace()

UPDATE `table_name` SET `field_name` = replace (`field_name`,'from_str','to_str') WHERE `field_name` LIKE '%from_str%'

illustrate:

table_name - the name of the table

field_name —— field name

from_str - the string to be replaced

to_str —— the string to be replaced

For example:

mysql> SELECT REPLACE('www.lvtao.net', 'www', 'http://www');

-> 'https://www.lvtao.net'

This function is multi-byte safe, which means you don't have to consider whether it is Chinese characters or English characters.

Summarize

This is the end of this article about mysql replace field part and mysql replace function replace(). For more relevant mysql replace field content, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!