mysql 查找替换

update products set price = replace(price,’天’,’月’);

 

update TABLE set f1 = replace(f1,’str_old’,’str_new’);