替换字符串空格、tab制表符

时间:2023-03-10 01:56:38
替换字符串空格、tab制表符
\    ASCII  (NUL ) 字符
\' ASCII 39 单引号 (“'” ) 字符
\" ASCII 34 双引号 (“"” ) 字符
\b ASCII 退格符
\n ASCII 换行符
\r ASCII 回车符
\t ASCII 制表符(TAB )
查询字段是否存在tab制表符:
select * from crm_special_link t where instr(t.link_number,chr())> 替换空格、tab制表符:
update crm_special_link set link_number = replace(link_number,' ','');
update crm_special_link set link_type = replace(link_type,' ','');
update crm_special_link set link_number = replace(link_number,chr(),'');