mysql remove space, line break etc

select count(*) from compounds as c where 1=1 and c.CAS REGEXP '[0-9]-[0-9]{2}-[0-9]{1}';

update compounds set CAS=REPLACE(CAS, '\r','');

update compounds set CAS=REPLACE(CAS, '\r\n','');

mysql> update chemmolc_customer.compounds set CAS=TRIM(CAS);

mysql> update a.compounds as cc, b.compounds as bc set cc.CAS=bc.CAS where cc.mol_id=bc.mol_id;