Advertisement
Guest User

update zip codes

a guest
Feb 1st, 2021
146
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. update res_partner set zip='20031' where TRIM(LOWER(city)) = LOWER('CESATE');
  2. update res_partner set zip='20033' where TRIM(LOWER(city)) = LOWER('SOLARO');
  3. update res_partner set zip='20034' where TRIM(LOWER(city)) = LOWER('SAN GIORGIO SU LEGNANO');
  4. update res_partner set zip='20035' where TRIM(LOWER(city)) = LOWER('VILLA CORTESE');
  5. update res_partner set zip='20036' where TRIM(LOWER(city)) = LOWER('DAIRAGO');
  6. update res_partner set zip='20038' where TRIM(LOWER(city)) = LOWER('BUSTO GAROLFO');
  7. update res_partner set zip='20039' where TRIM(LOWER(city)) = LOWER('CANEGRATE');
  8. update res_partner set zip='20042' where TRIM(LOWER(city)) = LOWER('PESSANO CON BORNAGO');
  9. update res_partner set zip='20043' where TRIM(LOWER(city)) = LOWER('VANZAGO');
  10. update res_partner set zip='20044' where TRIM(LOWER(city)) = LOWER('ARESE');
  11. update res_partner set zip='20045' where TRIM(LOWER(city)) = LOWER('LAINATE');
  12. update res_partner set zip='20046' where TRIM(LOWER(city)) = LOWER('CISLIANO');
  13. update res_partner set zip='20047' where TRIM(LOWER(city)) = LOWER('CUSAGO');
  14. update res_partner set zip='20048' where TRIM(LOWER(city)) = LOWER('PANTIGLIATE');
  15. update res_partner set zip='20049' where TRIM(LOWER(city)) = LOWER('SETTALA');
  16. update res_partner set zip='20050' where TRIM(LOWER(city)) = LOWER('LISCATE');
  17. update res_partner set zip='20051' where TRIM(LOWER(city)) = LOWER('CASSINA DE'' PECCHI');
  18. update res_partner set zip='20052' where TRIM(LOWER(city)) = LOWER('VIGNATE');
  19. update res_partner set zip='20053' where TRIM(LOWER(city)) = LOWER('RODANO');
  20. update res_partner set zip='20054' where TRIM(LOWER(city)) = LOWER('SEGRATE');
  21. update res_partner set zip='20055' where TRIM(LOWER(city)) = LOWER('VIMODRONE');
  22. update res_partner set zip='20057' where TRIM(LOWER(city)) = LOWER('ASSAGO');
  23. update res_partner set zip='20058' where TRIM(LOWER(city)) = LOWER('ZIBIDO SAN GIACOMO');
  24. update res_partner set zip='20059' where TRIM(LOWER(city)) = LOWER('CASARILE');
  25. update res_partner set zip='20041' where TRIM(LOWER(city)) = LOWER('BUSSERO');
  26. update res_partner set zip='20072' where TRIM(LOWER(city)) = LOWER('PIEVE EMANUELE');
  27. update res_partner set zip='20073' where TRIM(LOWER(city)) = LOWER('OPERA');
  28. update res_partner set zip='20074' where TRIM(LOWER(city)) = LOWER('CARPIANO');
  29. update res_partner set zip='20075' where TRIM(LOWER(city)) = LOWER('COLTURANO');
  30. update res_partner set zip='20076' where TRIM(LOWER(city)) = LOWER('MEDIGLIA');
  31. update res_partner set zip='20079' where TRIM(LOWER(city)) = LOWER('BASIGLIO');
  32. update res_partner set zip='20001' where TRIM(LOWER(city)) = LOWER('INVERUNO');
  33. update res_partner set zip='20008' where TRIM(LOWER(city)) = LOWER('BAREGGIO');
  34. update res_partner set zip='20007' where TRIM(LOWER(city)) = LOWER('CORNAREDO');
  35. update res_partner set zip='20004' where TRIM(LOWER(city)) = LOWER('ARLUNO');
  36. update res_partner set zip='20005' where TRIM(LOWER(city)) = LOWER('POGLIANO MILANESE');
  37. update res_partner set zip='20003' where TRIM(LOWER(city)) = LOWER('CASOREZZO');
  38. update res_partner set zip='20002' where TRIM(LOWER(city)) = LOWER('OSSONA');
  39. update res_partner set zip='20006' where TRIM(LOWER(city)) = LOWER('PREGNANA MILANESE');
  40. update res_partner set zip='20009' where TRIM(LOWER(city)) = LOWER('VITTUONE');
  41.  
  42.  
  43. update res_better_zip set name='20031' where TRIM(LOWER(city)) = LOWER('CESATE');
  44. update res_better_zip set name='20033' where TRIM(LOWER(city)) = LOWER('SOLARO');
  45. update res_better_zip set name='20034' where TRIM(LOWER(city)) = LOWER('SAN GIORGIO SU LEGNANO');
  46. update res_better_zip set name='20035' where TRIM(LOWER(city)) = LOWER('VILLA CORTESE');
  47. update res_better_zip set name='20036' where TRIM(LOWER(city)) = LOWER('DAIRAGO');
  48. update res_better_zip set name='20038' where TRIM(LOWER(city)) = LOWER('BUSTO GAROLFO');
  49. update res_better_zip set name='20039' where TRIM(LOWER(city)) = LOWER('CANEGRATE');
  50. update res_better_zip set name='20042' where TRIM(LOWER(city)) = LOWER('PESSANO CON BORNAGO');
  51. update res_better_zip set name='20043' where TRIM(LOWER(city)) = LOWER('VANZAGO');
  52. update res_better_zip set name='20044' where TRIM(LOWER(city)) = LOWER('ARESE');
  53. update res_better_zip set name='20045' where TRIM(LOWER(city)) = LOWER('LAINATE');
  54. update res_better_zip set name='20046' where TRIM(LOWER(city)) = LOWER('CISLIANO');
  55. update res_better_zip set name='20047' where TRIM(LOWER(city)) = LOWER('CUSAGO');
  56. update res_better_zip set name='20048' where TRIM(LOWER(city)) = LOWER('PANTIGLIATE');
  57. update res_better_zip set name='20049' where TRIM(LOWER(city)) = LOWER('SETTALA');
  58. update res_better_zip set name='20050' where TRIM(LOWER(city)) = LOWER('LISCATE');
  59. update res_better_zip set name='20051' where TRIM(LOWER(city)) = LOWER('CASSINA DE'' PECCHI');
  60. update res_better_zip set name='20052' where TRIM(LOWER(city)) = LOWER('VIGNATE');
  61. update res_better_zip set name='20053' where TRIM(LOWER(city)) = LOWER('RODANO');
  62. update res_better_zip set name='20054' where TRIM(LOWER(city)) = LOWER('SEGRATE');
  63. update res_better_zip set name='20055' where TRIM(LOWER(city)) = LOWER('VIMODRONE');
  64. update res_better_zip set name='20057' where TRIM(LOWER(city)) = LOWER('ASSAGO');
  65. update res_better_zip set name='20058' where TRIM(LOWER(city)) = LOWER('ZIBIDO SAN GIACOMO');
  66. update res_better_zip set name='20059' where TRIM(LOWER(city)) = LOWER('CASARILE');
  67. update res_better_zip set name='20041' where TRIM(LOWER(city)) = LOWER('BUSSERO');
  68. update res_better_zip set name='20072' where TRIM(LOWER(city)) = LOWER('PIEVE EMANUELE');
  69. update res_better_zip set name='20073' where TRIM(LOWER(city)) = LOWER('OPERA');
  70. update res_better_zip set name='20074' where TRIM(LOWER(city)) = LOWER('CARPIANO');
  71. update res_better_zip set name='20075' where TRIM(LOWER(city)) = LOWER('COLTURANO');
  72. update res_better_zip set name='20076' where TRIM(LOWER(city)) = LOWER('MEDIGLIA');
  73. update res_better_zip set name='20079' where TRIM(LOWER(city)) = LOWER('BASIGLIO');
  74. update res_better_zip set name='20001' where TRIM(LOWER(city)) = LOWER('INVERUNO');
  75. update res_better_zip set name='20008' where TRIM(LOWER(city)) = LOWER('BAREGGIO');
  76. update res_better_zip set name='20007' where TRIM(LOWER(city)) = LOWER('CORNAREDO');
  77. update res_better_zip set name='20004' where TRIM(LOWER(city)) = LOWER('ARLUNO');
  78. update res_better_zip set name='20005' where TRIM(LOWER(city)) = LOWER('POGLIANO MILANESE');
  79. update res_better_zip set name='20003' where TRIM(LOWER(city)) = LOWER('CASOREZZO');
  80. update res_better_zip set name='20002' where TRIM(LOWER(city)) = LOWER('OSSONA');
  81. update res_better_zip set name='20006' where TRIM(LOWER(city)) = LOWER('PREGNANA MILANESE');
  82. update res_better_zip set name='20009' where TRIM(LOWER(city)) = LOWER('VITTUONE');
Advertisement
RAW Paste Data Copied
Advertisement