请教SQL删除特定字符
https://zhidao.baidu.com/question/557960868.html
--sql语句为:UPDATE `table_name` SET `field_name` = replace (`field_name`,’from_str’,'to_str’)--代码说明:--table_name —— 表的名字,field_name —— 字段名,--from_str —— 需要替换的字符串,to_str —— 替换成的字符串。update ABD set A1=REPLACE(A1,'rw','') where A1 like'%rw%'UPDATE `xlsdeal`SET RECORD_DATE = replace('RECORD_DATE',' 报表日期:','')WHERE RECORD_DATE like'% 报表日期:%'UPDATE `xlsdeal`SET RECORD_DATE = replace(RECORD_DATE,' 报表日期:','')WHERE RECORD_DATE like'% 报表日期:%'