MySQL query string replacement statement Summary (Database string replacement)

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

Note:
Table_name -- table name
Field_name -- field name
From_str -- string to be replaced
To_str -- string to be replaced

A query is run today.
Update ubk_vhost_list set userid = Replace (userid, '20160901', '20160901 ')

For more detailed MySQL string replacement statements, refer to the followingArticle