sql: 用replace函数替换字段中的字符串

1.select replace(fld,"aaa","bbb") from tbl;

2.update tbl set fld=replace(fld,"aaa","bbb") ;