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