Method for updating some data in a Mysql field _ MySQL

Method for updating part of data in a Mysql field bitsCN.com

How to update some data in a Mysql field

Mysql updates some data in the field in the first case:

Update tab set A = concat (substring (A, 1, 3), 'BBB ');

Start from 1 character of A and add 'BBB 'to a. If the original value of A is '123aaa', it is updated to '123bbb.

What if we want to replace 1 in field A with 2?

For example, if a = 2211 is to be replaced with 2222, it means to replace 1 with 2.

Write the SQL statement as follows: update table set a = REPLACE (a, '1', '2 ');

BitsCN.com