mysql去除空格和換行

NO IMAGE

UPDATE branch SET branch_name = replace(replace(branch_name,CHAR(13),”),CHAR(10),”)