如下:
update users_settings set `ConfigValue` = replace(configvalue,' fromstr' ,'tostr') where `ConfigName`='aclearcase/" target="_blank" >ccesslist'
原文转自:http://www.ltesting.net