mysql replace

replace(object, search,replace)

示例：update table set col1 = replace(col1, 'a', 'A');

将col1字段中的小写a替换成大写A