Mysql query string Substitution statement summary (database string substitution) _mysql

Replace the character 10005 in the field userid in the Ubk_vhost_list table with 10010

UPDATE ' table_name ' SET ' field_name ' = replace (' Field_name ', ' from_str ', ' to_str ') WHERE ' field_name ' like '%from_str% '

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

A query was run today
UPDATE ubk_vhost_list SET userid = replace (userid, ' 10005 ', ' 10010 ')

A more detailed MySQL string substitution statement can refer to the following article