SELECT * from bas_cm_customer_linkman WHERE linkman like '%'|| chr(13)||'%' or linkman like '%'||chr(10)||'%';
update bas_cm_customer_linkman
SET linkman = REPLACE(linkman, CHR(10), '')
WHERE linkman like '%'||chr(10)||'%';
update bas_cm_customer_linkman
SET linkman = REPLACE(linkman, CHR(13), '')
WHERE linkman like '%'|| chr(13)||'%';
Postgresql查询出包含换行符的数据并替换掉
于 2021-03-22 20:16:24 首次发布