Mysql Query string replacement Statement Summary (database string replacement) _ MySQL

Mysql Query string replacement Statement Summary (database string replacement) bitsCN.com replace character 10005 in the userid field 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 following article bitsCN.com