update/replace column content

//mySQL

UPDATE [table_name]
set [column_name]=REPLACE([column_name], '[before]', '[after]')


UPDATE s_his
set s_his_date=REPLACE(s_his_date, 'Dec 7, 2011', '2011-12-07')