mysql replace

replace(object, search,replace)

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

將col1欄位中的小寫a替換成大寫A