2020-02-16 标签:mysql,查询,字符串,替换,语句,小结,数据库,ubk,vhost,list,字段,userid,字符,10005,10010,update,table,n,ame

将ubk_vhost_list表中的字段userid中的字符10005替换成10010 UPDATE `table_name` SET `field_name` = replace (`field_name`,'from_str','to_str') WHERE `field_name` LIKE