电脑技术学习

mysql中的替换语句

dn001

如下:

update users_settings set `ConfigValue` = replace(configvalue,' fromstr' ,'tostr') where `ConfigName`='accesslist'