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

原文地址:https://www.cnblogs.com/yzpopulation/p/14103746.html