update zip codes

update res_partner set zip='20031' where TRIM(LOWER(city)) = LOWER('CESATE');
update res_partner set zip='20033' where TRIM(LOWER(city)) = LOWER('SOLARO');
update res_partner set zip='20034' where TRIM(LOWER(city)) = LOWER('SAN GIORGIO SU LEGNANO');
update res_partner set zip='20035' where TRIM(LOWER(city)) = LOWER('VILLA CORTESE');
update res_partner set zip='20036' where TRIM(LOWER(city)) = LOWER('DAIRAGO');
update res_partner set zip='20038' where TRIM(LOWER(city)) = LOWER('BUSTO GAROLFO');
update res_partner set zip='20039' where TRIM(LOWER(city)) = LOWER('CANEGRATE');
update res_partner set zip='20042' where TRIM(LOWER(city)) = LOWER('PESSANO CON BORNAGO');
update res_partner set zip='20043' where TRIM(LOWER(city)) = LOWER('VANZAGO');
update res_partner set zip='20044' where TRIM(LOWER(city)) = LOWER('ARESE');
update res_partner set zip='20045' where TRIM(LOWER(city)) = LOWER('LAINATE');
update res_partner set zip='20046' where TRIM(LOWER(city)) = LOWER('CISLIANO');
update res_partner set zip='20047' where TRIM(LOWER(city)) = LOWER('CUSAGO');
update res_partner set zip='20048' where TRIM(LOWER(city)) = LOWER('PANTIGLIATE');
update res_partner set zip='20049' where TRIM(LOWER(city)) = LOWER('SETTALA');
update res_partner set zip='20050' where TRIM(LOWER(city)) = LOWER('LISCATE');
update res_partner set zip='20051' where TRIM(LOWER(city)) = LOWER('CASSINA DE'' PECCHI');
update res_partner set zip='20052' where TRIM(LOWER(city)) = LOWER('VIGNATE');
update res_partner set zip='20053' where TRIM(LOWER(city)) = LOWER('RODANO');
update res_partner set zip='20054' where TRIM(LOWER(city)) = LOWER('SEGRATE');
update res_partner set zip='20055' where TRIM(LOWER(city)) = LOWER('VIMODRONE');
update res_partner set zip='20057' where TRIM(LOWER(city)) = LOWER('ASSAGO');
update res_partner set zip='20058' where TRIM(LOWER(city)) = LOWER('ZIBIDO SAN GIACOMO');
update res_partner set zip='20059' where TRIM(LOWER(city)) = LOWER('CASARILE');
update res_partner set zip='20041' where TRIM(LOWER(city)) = LOWER('BUSSERO');
update res_partner set zip='20072' where TRIM(LOWER(city)) = LOWER('PIEVE EMANUELE');
update res_partner set zip='20073' where TRIM(LOWER(city)) = LOWER('OPERA');
update res_partner set zip='20074' where TRIM(LOWER(city)) = LOWER('CARPIANO');
update res_partner set zip='20075' where TRIM(LOWER(city)) = LOWER('COLTURANO');
update res_partner set zip='20076' where TRIM(LOWER(city)) = LOWER('MEDIGLIA');
update res_partner set zip='20079' where TRIM(LOWER(city)) = LOWER('BASIGLIO');
update res_partner set zip='20001' where TRIM(LOWER(city)) = LOWER('INVERUNO');
update res_partner set zip='20008' where TRIM(LOWER(city)) = LOWER('BAREGGIO');
update res_partner set zip='20007' where TRIM(LOWER(city)) = LOWER('CORNAREDO');
update res_partner set zip='20004' where TRIM(LOWER(city)) = LOWER('ARLUNO');
update res_partner set zip='20005' where TRIM(LOWER(city)) = LOWER('POGLIANO MILANESE');
update res_partner set zip='20003' where TRIM(LOWER(city)) = LOWER('CASOREZZO');
update res_partner set zip='20002' where TRIM(LOWER(city)) = LOWER('OSSONA');
update res_partner set zip='20006' where TRIM(LOWER(city)) = LOWER('PREGNANA MILANESE');
update res_partner set zip='20009' where TRIM(LOWER(city)) = LOWER('VITTUONE');


update res_better_zip set name='20031' where TRIM(LOWER(city)) = LOWER('CESATE');
update res_better_zip set name='20033' where TRIM(LOWER(city)) = LOWER('SOLARO');
update res_better_zip set name='20034' where TRIM(LOWER(city)) = LOWER('SAN GIORGIO SU LEGNANO');
update res_better_zip set name='20035' where TRIM(LOWER(city)) = LOWER('VILLA CORTESE');
update res_better_zip set name='20036' where TRIM(LOWER(city)) = LOWER('DAIRAGO');
update res_better_zip set name='20038' where TRIM(LOWER(city)) = LOWER('BUSTO GAROLFO');
update res_better_zip set name='20039' where TRIM(LOWER(city)) = LOWER('CANEGRATE');
update res_better_zip set name='20042' where TRIM(LOWER(city)) = LOWER('PESSANO CON BORNAGO');
update res_better_zip set name='20043' where TRIM(LOWER(city)) = LOWER('VANZAGO');
update res_better_zip set name='20044' where TRIM(LOWER(city)) = LOWER('ARESE');
update res_better_zip set name='20045' where TRIM(LOWER(city)) = LOWER('LAINATE');
update res_better_zip set name='20046' where TRIM(LOWER(city)) = LOWER('CISLIANO');
update res_better_zip set name='20047' where TRIM(LOWER(city)) = LOWER('CUSAGO');
update res_better_zip set name='20048' where TRIM(LOWER(city)) = LOWER('PANTIGLIATE');
update res_better_zip set name='20049' where TRIM(LOWER(city)) = LOWER('SETTALA');
update res_better_zip set name='20050' where TRIM(LOWER(city)) = LOWER('LISCATE');
update res_better_zip set name='20051' where TRIM(LOWER(city)) = LOWER('CASSINA DE'' PECCHI');
update res_better_zip set name='20052' where TRIM(LOWER(city)) = LOWER('VIGNATE');
update res_better_zip set name='20053' where TRIM(LOWER(city)) = LOWER('RODANO');
update res_better_zip set name='20054' where TRIM(LOWER(city)) = LOWER('SEGRATE');
update res_better_zip set name='20055' where TRIM(LOWER(city)) = LOWER('VIMODRONE');
update res_better_zip set name='20057' where TRIM(LOWER(city)) = LOWER('ASSAGO');
update res_better_zip set name='20058' where TRIM(LOWER(city)) = LOWER('ZIBIDO SAN GIACOMO');
update res_better_zip set name='20059' where TRIM(LOWER(city)) = LOWER('CASARILE');
update res_better_zip set name='20041' where TRIM(LOWER(city)) = LOWER('BUSSERO');
update res_better_zip set name='20072' where TRIM(LOWER(city)) = LOWER('PIEVE EMANUELE');
update res_better_zip set name='20073' where TRIM(LOWER(city)) = LOWER('OPERA');
update res_better_zip set name='20074' where TRIM(LOWER(city)) = LOWER('CARPIANO');
update res_better_zip set name='20075' where TRIM(LOWER(city)) = LOWER('COLTURANO');
update res_better_zip set name='20076' where TRIM(LOWER(city)) = LOWER('MEDIGLIA');
update res_better_zip set name='20079' where TRIM(LOWER(city)) = LOWER('BASIGLIO');
update res_better_zip set name='20001' where TRIM(LOWER(city)) = LOWER('INVERUNO');
update res_better_zip set name='20008' where TRIM(LOWER(city)) = LOWER('BAREGGIO');
update res_better_zip set name='20007' where TRIM(LOWER(city)) = LOWER('CORNAREDO');
update res_better_zip set name='20004' where TRIM(LOWER(city)) = LOWER('ARLUNO');
update res_better_zip set name='20005' where TRIM(LOWER(city)) = LOWER('POGLIANO MILANESE');
update res_better_zip set name='20003' where TRIM(LOWER(city)) = LOWER('CASOREZZO');
update res_better_zip set name='20002' where TRIM(LOWER(city)) = LOWER('OSSONA');
update res_better_zip set name='20006' where TRIM(LOWER(city)) = LOWER('PREGNANA MILANESE');
update res_better_zip set name='20009' where TRIM(LOWER(city)) = LOWER('VITTUONE');