sql 替换某个字段的值

show variables like 'SQL_SAFE_UPDATES';
SET SQL_SAFE_UPDATES = 0;
update `tumor` set NONCODEId=replace(NONCODEId,'Not Found.','N.A.');