Mysql utf8 替换空白字符


CREATE FUNCTION clean(strs VARCHAR(255))
RETURNS VARCHAR(255) 
BEGIN
 return REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(strs,0x00,''),0x01,''),0x02,''),0x03,''),0x04,''),0x05,''),0x06,''),0x07,''),0x08,''),0x09,''),0x0a,''),0x0b,''),0x0e,''),0x0f,''),0x0c,''),0x0d,''),0x10,''),0x11,''),0x12,''),0x13,''),0x14,''),0x15,''),0x18,''),0x19,''),0x20,''),0x16,''),0x17,''),0x1f,''),0x1a,''),0x1b,''),0x1c,''),0x1d,''),0x1e,''),0x7f,'');
END


##mysql
select regexp_replace("col", '\\s+', '')  from sheet

##postgres
select regexp_replace("col", '\s+', '','g')  from sheet

posted @ 2020-12-08 17:23  月渊  阅读(639)  评论(0编辑  收藏  举报