SELECT * FROM TABLENAME
结果如下:
UPDATE TABLENAME SET xx=replace(replace(replace(replace(xx,'小时随访','H'),'天随访','D'),'个月随访','M'),'年随访','Y')
替换后结果如下:
SELECT * FROM TABLENAME
结果如下:
UPDATE TABLENAME SET xx=replace(replace(replace(replace(xx,'小时随访','H'),'天随访','D'),'个月随访','M'),'年随访','Y')
替换后结果如下: