-- Update pincodes and append to billing_address for customers
-- Matched from master-1.csv and master-2.csv by name
-- Generated on 2026-04-02

UPDATE `customers` SET `pincode` = '400018', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400018'), `billing_address`) WHERE `gst_number` = '27AAOPT7558G1ZX';
UPDATE `customers` SET `pincode` = '500003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 500003'), `billing_address`) WHERE `gst_number` = '36AABCA4938P1Z8';
UPDATE `customers` SET `pincode` = '281005', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 281005'), `billing_address`) WHERE `gst_number` = '09IZBPS7079K1ZD';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFA2798R1ZS';
UPDATE `customers` SET `pincode` = '401105', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401105'), `billing_address`) WHERE `gst_number` = '27ALLPM5777A1ZV';
UPDATE `customers` SET `pincode` = '382430', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 382430'), `billing_address`) WHERE `gst_number` = '24ABFFA1280J1ZO';
UPDATE `customers` SET `pincode` = '400007', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400007'), `billing_address`) WHERE `gst_number` = '27AAQFA7738M1ZO';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AGLPJ9083H1ZW';
UPDATE `customers` SET `pincode` = '500003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 500003'), `billing_address`) WHERE `gst_number` = '36ACEPH2132G1Z4';
UPDATE `customers` SET `pincode` = '302029', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 302029'), `billing_address`) WHERE `gst_number` = '08AAECA6828P1Z3';
UPDATE `customers` SET `pincode` = '201301', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 201301'), `billing_address`) WHERE `gst_number` = '09AAECA6828P1Z1';
UPDATE `customers` SET `pincode` = '110092', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110092'), `billing_address`) WHERE `gst_number` = '07AAECA6828P1Z5';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AZVPS4307G1ZV';
UPDATE `customers` SET `pincode` = '110006', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110006'), `billing_address`) WHERE `gst_number` = '07AADPA4788L1ZG';
UPDATE `customers` SET `pincode` = '625528', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 625528'), `billing_address`) WHERE `gst_number` = '33ARHPV7025L1ZD';
UPDATE `customers` SET `pincode` = '400092', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400092'), `billing_address`) WHERE `gst_number` = '27AEIPD9649C1ZF';
UPDATE `customers` SET `pincode` = '400092', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400092'), `billing_address`) WHERE `gst_number` = '27AAPPS9039N1ZM';
UPDATE `customers` SET `pincode` = '400001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400001'), `billing_address`) WHERE `gst_number` = '27AADCA2140D1ZC';
UPDATE `customers` SET `pincode` = '500012', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 500012'), `billing_address`) WHERE `gst_number` = '36AMDPK5976E3ZT';
UPDATE `customers` SET `pincode` = '400080', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400080'), `billing_address`) WHERE `gst_number` = '27ABAPS2559M1Z6';
UPDATE `customers` SET `pincode` = '400070', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400070'), `billing_address`) WHERE `gst_number` = '27CSLPK8184L1ZV';
UPDATE `customers` SET `pincode` = '411002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 411002'), `billing_address`) WHERE `gst_number` = '27AAIFA8340H1ZF';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAQPB4872M1Z5';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27ARPPP7487E1Z1';
UPDATE `customers` SET `pincode` = '380001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 380001'), `billing_address`) WHERE `gst_number` = '24ABOPR9276J1ZT';
UPDATE `customers` SET `pincode` = '400001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400001'), `billing_address`) WHERE `gst_number` = '27ACWPL4322J1Z6';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AABPT8144P1ZZ';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AABFA0318C1ZA';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFA2471K1ZK';
UPDATE `customers` SET `pincode` = '401210', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401210'), `billing_address`) WHERE `gst_number` = '27AEDPN6215R1ZZ';
UPDATE `customers` SET `pincode` = '401101', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401101'), `billing_address`) WHERE `gst_number` = '27AHYPM5663L1ZB';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AABPP5995N1ZU';
UPDATE `customers` SET `pincode` = '400009', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400009'), `billing_address`) WHERE `gst_number` = '27AAJFA7407L1Z7';
UPDATE `customers` SET `pincode` = '700001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 700001'), `billing_address`) WHERE `gst_number` = '19AAEFA5228J1ZE';
UPDATE `customers` SET `pincode` = '560058', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 560058'), `billing_address`) WHERE `gst_number` = '29AAHCM4010A1Z1';
UPDATE `customers` SET `pincode` = '342002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 342002'), `billing_address`) WHERE `gst_number` = '08CDOPS1044R1ZQ';
UPDATE `customers` SET `pincode` = '360004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360004'), `billing_address`) WHERE `gst_number` = '24AAYPV6344G1Z1';
UPDATE `customers` SET `pincode` = '641001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 641001'), `billing_address`) WHERE `gst_number` = '33AAYFA6008J1Z8';
UPDATE `customers` SET `pincode` = '400093', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400093'), `billing_address`) WHERE `gst_number` = '27AAJFA6712C1ZS';
UPDATE `customers` SET `pincode` = '302003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 302003'), `billing_address`) WHERE `id` = 55;
UPDATE `customers` SET `pincode` = '395003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 395003'), `billing_address`) WHERE `gst_number` = '24ADOPS4416K1Z6';
UPDATE `customers` SET `pincode` = '401107', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401107'), `billing_address`) WHERE `gst_number` = '27ABPFA8213K1Z3';
UPDATE `customers` SET `pincode` = '560002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 560002'), `billing_address`) WHERE `gst_number` = '29AAPPB0207R1ZF';
UPDATE `customers` SET `pincode` = '400001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400001'), `billing_address`) WHERE `gst_number` = '09CFYPS3727R1Z0';
UPDATE `customers` SET `pincode` = '400067', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400067'), `billing_address`) WHERE `gst_number` = '27AAGCA9220M1ZF';
UPDATE `customers` SET `pincode` = '400033', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400033'), `billing_address`) WHERE `gst_number` = '27ACJPJ1261F2ZT';
UPDATE `customers` SET `pincode` = '401209', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401209'), `billing_address`) WHERE `gst_number` = '27AHGPR1492N1ZP';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFA6537G1ZM';
UPDATE `customers` SET `pincode` = '452015', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 452015'), `billing_address`) WHERE `gst_number` = '23AALCA4818L1ZI';
UPDATE `customers` SET `pincode` = '400022', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400022'), `billing_address`) WHERE `gst_number` = '27AABPG4673Q1Z8';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27BAQPS0727K1Z5';
UPDATE `customers` SET `pincode` = '440002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 440002'), `billing_address`) WHERE `gst_number` = '27AANFM5747R1Z8';
UPDATE `customers` SET `pincode` = '400078', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400078'), `billing_address`) WHERE `gst_number` = '27AIHPN4146P1ZO';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFA3616J1ZP';
UPDATE `customers` SET `pincode` = '363641', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 363641'), `billing_address`) WHERE `gst_number` = '24BCAPS7322E1ZV';
UPDATE `customers` SET `pincode` = '396171', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 396171'), `billing_address`) WHERE `gst_number` = '24ABBFA0583A2Z6';
UPDATE `customers` SET `pincode` = '411026', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 411026'), `billing_address`) WHERE `gst_number` = '27AOCPM0802J1Z7';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAEPG6153A1Z7';
UPDATE `customers` SET `pincode` = '110006', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110006'), `billing_address`) WHERE `gst_number` = '07ABDFA2564K1ZF';
UPDATE `customers` SET `pincode` = '411034', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 411034'), `billing_address`) WHERE `gst_number` = '27AWEPB3934E1ZW';
UPDATE `customers` SET `pincode` = '360003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360003'), `billing_address`) WHERE `gst_number` = '24AFBPJ0348E1Z2';
UPDATE `customers` SET `pincode` = '400004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400004'), `billing_address`) WHERE `gst_number` = '27AAIPU0869M1ZX';
UPDATE `customers` SET `pincode` = '400013', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400013'), `billing_address`) WHERE `gst_number` = '27ABWPH0067P1ZY';
UPDATE `customers` SET `pincode` = '411002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 411002'), `billing_address`) WHERE `gst_number` = '27AACPO4791L1Z6';
UPDATE `customers` SET `pincode` = '400007', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400007'), `billing_address`) WHERE `gst_number` = '27ACHPJ6723E1ZP';
UPDATE `customers` SET `pincode` = '600050', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 600050'), `billing_address`) WHERE `gst_number` = '33AOAPK3181N1ZW';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AETPG6522L1Z0';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAEFB7702L1ZD';
UPDATE `customers` SET `pincode` = '360002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360002'), `billing_address`) WHERE `gst_number` = '24AGBPS8298K1ZP';
UPDATE `customers` SET `pincode` = '400043', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400043'), `billing_address`) WHERE `id` = 106;
UPDATE `customers` SET `pincode` = '400092', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400092'), `billing_address`) WHERE `gst_number` = '27ABDPS4741E1ZO';
UPDATE `customers` SET `pincode` = '782001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 782001'), `billing_address`) WHERE `gst_number` = '18AAUFB7714L1ZS';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AFEPR3336P1ZW';
UPDATE `customers` SET `pincode` = '400004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400004'), `billing_address`) WHERE `gst_number` = '27AAVFB1772B1ZF';
UPDATE `customers` SET `pincode` = '400091', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400091'), `billing_address`) WHERE `gst_number` = '27AIYPJ5018K1ZO';
UPDATE `customers` SET `pincode` = '431136', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 431136'), `billing_address`) WHERE `gst_number` = '27AAHCB4724C1ZZ';
UPDATE `customers` SET `pincode` = '400080', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400080'), `billing_address`) WHERE `gst_number` = '27AFKPM7354N1ZP';
UPDATE `customers` SET `pincode` = '400067', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400067'), `billing_address`) WHERE `gst_number` = '27AMTPS1790A1ZQ';
UPDATE `customers` SET `pincode` = '400068', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400068'), `billing_address`) WHERE `gst_number` = '27BAOPS5002H1ZK';
UPDATE `customers` SET `pincode` = '400612', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400612'), `billing_address`) WHERE `gst_number` = '27ANSPB0599A1Z1';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AARFB4529J1Z1';
UPDATE `customers` SET `pincode` = '400612', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400612'), `billing_address`) WHERE `gst_number` = '27BDYPB7113B1ZP';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFC0825B1Z7';
UPDATE `customers` SET `pincode` = '500052', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 500052'), `billing_address`) WHERE `gst_number` = '36AAJCC4340B1Z3';
UPDATE `customers` SET `pincode` = '400011', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400011'), `billing_address`) WHERE `gst_number` = '27AAACC2088B1Z2';
UPDATE `customers` SET `pincode` = '400001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400001'), `billing_address`) WHERE `gst_number` = '27AAAFC1177A1Z2';
UPDATE `customers` SET `pincode` = '144002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144002'), `billing_address`) WHERE `gst_number` = '03AADFC4253C1Z6';
UPDATE `customers` SET `pincode` = '620008', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 620008'), `billing_address`) WHERE `gst_number` = '33AAMPS6885M1ZQ';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AEIPM3649B1ZK';
UPDATE `customers` SET `pincode` = '400102', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400102'), `billing_address`) WHERE `gst_number` = '27AAGCC9056P1ZX';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAQFC3658N1ZP';
UPDATE `customers` SET `pincode` = '411033', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 411033'), `billing_address`) WHERE `gst_number` = '27AGOPC3253D1ZO';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AMYPS1101J1ZP';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFC1212G1Z6';
UPDATE `customers` SET `pincode` = '201002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 201002'), `billing_address`) WHERE `gst_number` = '09AOXPK6131R1ZW';
UPDATE `customers` SET `pincode` = '202002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 202002'), `billing_address`) WHERE `gst_number` = '09ADNPK9781A1Z6';
UPDATE `customers` SET `pincode` = '400077', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400077'), `billing_address`) WHERE `gst_number` = '27AACCC4488M1Z5';
UPDATE `customers` SET `pincode` = '400093', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400093'), `billing_address`) WHERE `gst_number` = '27AACCD1551G1ZZ';
UPDATE `customers` SET `pincode` = '395004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 395004'), `billing_address`) WHERE `gst_number` = '24EXCPS4173K1Z3';
UPDATE `customers` SET `pincode` = '401208', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401208'), `billing_address`) WHERE `gst_number` = '27ADJPL0039J1ZJ';
UPDATE `customers` SET `pincode` = '400092', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400092'), `billing_address`) WHERE `gst_number` = '27BFAPS5479D1Z7';
UPDATE `customers` SET `pincode` = '110006', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110006'), `billing_address`) WHERE `gst_number` = '07DSNPD4795P1ZS';
UPDATE `customers` SET `pincode` = '400612', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400612'), `billing_address`) WHERE `gst_number` = '27CCNPB3424N1ZE';
UPDATE `customers` SET `pincode` = '400606', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400606'), `billing_address`) WHERE `gst_number` = '27AAICD1657K1ZD';
UPDATE `customers` SET `pincode` = '500001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 500001'), `billing_address`) WHERE `gst_number` = '36AABFD8065B1ZQ';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AFFPD8301R1Z6';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27ADPPD4906N1Z5';
UPDATE `customers` SET `pincode` = '400708', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400708'), `billing_address`) WHERE `gst_number` = '27AIOPC1546K1Z4';
UPDATE `customers` SET `pincode` = '474001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 474001'), `billing_address`) WHERE `gst_number` = '23ECVPR3915Q1ZM';
UPDATE `customers` SET `pincode` = '400060', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400060'), `billing_address`) WHERE `gst_number` = '27AFYPJ8647P1Z4';
UPDATE `customers` SET `pincode` = '500042', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 500042'), `billing_address`) WHERE `gst_number` = '36BRIPR1801G1ZW';
UPDATE `customers` SET `pincode` = '361004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 361004'), `billing_address`) WHERE `gst_number` = '24AQNPP0016E1Z8';
UPDATE `customers` SET `pincode` = '400097', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400097'), `billing_address`) WHERE `gst_number` = '27BHEPS0069M1ZW';
UPDATE `customers` SET `pincode` = '400062', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400062'), `billing_address`) WHERE `gst_number` = '27APZPS3565C1Z9';
UPDATE `customers` SET `pincode` = '411002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 411002'), `billing_address`) WHERE `gst_number` = '27AAAFD8878K1ZU';
UPDATE `customers` SET `pincode` = '400092', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400092'), `billing_address`) WHERE `gst_number` = '27AABPP8624N1Z6';
UPDATE `customers` SET `pincode` = '400091', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400091'), `billing_address`) WHERE `gst_number` = '27AUJPS4077L1ZV';
UPDATE `customers` SET `pincode` = '400086', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400086'), `billing_address`) WHERE `gst_number` = '27AAEPD4357R1Z9';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAKPS9079F1Z0';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AABFD9794R1ZE';
UPDATE `customers` SET `pincode` = '282005', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 282005'), `billing_address`) WHERE `gst_number` = '09BFVPK6292M1ZC';
UPDATE `customers` SET `pincode` = '625528', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 625528'), `billing_address`) WHERE `gst_number` = '33AOYPB0427L1ZU';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFD5544L1ZB';
UPDATE `customers` SET `pincode` = '400102', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400102'), `billing_address`) WHERE `gst_number` = '27AEQPM4913C1ZH';
UPDATE `customers` SET `pincode` = '500037', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 500037'), `billing_address`) WHERE `gst_number` = '36AABCD6280D1ZV';
UPDATE `customers` SET `pincode` = '201002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 201002'), `billing_address`) WHERE `gst_number` = '09AKXPA5123H1Z1';
UPDATE `customers` SET `pincode` = '360002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360002'), `billing_address`) WHERE `gst_number` = '24AACFE5131A1ZA';
UPDATE `customers` SET `pincode` = '360002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360002'), `billing_address`) WHERE `gst_number` = '24AABFE8119R1Z2';
UPDATE `customers` SET `pincode` = '360002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360002'), `billing_address`) WHERE `gst_number` = '24AACFE0587A1Z0';
UPDATE `customers` SET `pincode` = '360003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360003'), `billing_address`) WHERE `gst_number` = '24AIFPR1707A1ZU';
UPDATE `customers` SET `pincode` = '411037', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 411037'), `billing_address`) WHERE `gst_number` = '27AADPH2369A1Z5';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AABFE9161D1ZL';
UPDATE `customers` SET `pincode` = '110095', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110095'), `billing_address`) WHERE `gst_number` = '07AANPP6056G1ZD';
UPDATE `customers` SET `pincode` = '500003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 500003'), `billing_address`) WHERE `gst_number` = '36BHLPP1906K3ZZ';
UPDATE `customers` SET `pincode` = '570001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 570001'), `billing_address`) WHERE `gst_number` = '29AAAFE4000E1Z4';
UPDATE `customers` SET `pincode` = '400096', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400096'), `billing_address`) WHERE `gst_number` = '27AABCE1722F1Z4';
UPDATE `customers` SET `pincode` = '600050', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 600050'), `billing_address`) WHERE `gst_number` = '33DJZPS2606K1ZK';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAGFE0725J1ZJ';
UPDATE `customers` SET `pincode` = '400016', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400016'), `billing_address`) WHERE `gst_number` = '27ADUPS7865G1ZK';
UPDATE `customers` SET `pincode` = '641001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 641001'), `billing_address`) WHERE `gst_number` = '33AABFG1780E1ZV';
UPDATE `customers` SET `pincode` = '110039', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110039'), `billing_address`) WHERE `gst_number` = '07ABAFG1113H1Z0';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AGCPK5604J1ZG';
UPDATE `customers` SET `pincode` = '341001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 341001'), `billing_address`) WHERE `gst_number` = '08BLNPM7394C1ZN';
UPDATE `customers` SET `pincode` = '400080', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400080'), `billing_address`) WHERE `gst_number` = '27ABAPS9191D1ZF';
UPDATE `customers` SET `pincode` = '401101', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401101'), `billing_address`) WHERE `gst_number` = '27AAGPD1339M1ZP';
UPDATE `customers` SET `pincode` = '360004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360004'), `billing_address`) WHERE `gst_number` = '24AARPN6310R1Z3';
UPDATE `customers` SET `pincode` = '110006', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110006'), `billing_address`) WHERE `gst_number` = '07AADFG5019Q1Z3';
UPDATE `customers` SET `pincode` = '401202', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401202'), `billing_address`) WHERE `gst_number` = '27APTPS0922D1ZQ';
UPDATE `customers` SET `pincode` = '636002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 636002'), `billing_address`) WHERE `gst_number` = '33AATFG2537P1ZT';
UPDATE `customers` SET `pincode` = '636002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 636002'), `billing_address`) WHERE `gst_number` = '33AAEFG5745J1ZC';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFG2766P1ZY';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27ABIPR5122K1ZE';
UPDATE `customers` SET `pincode` = '400064', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400064'), `billing_address`) WHERE `gst_number` = '27AAHCG5165E1ZL';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AACPS5534R1ZZ';
UPDATE `customers` SET `pincode` = '400080', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400080'), `billing_address`) WHERE `gst_number` = '27AABPS8321H1ZM';
UPDATE `customers` SET `pincode` = '400064', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400064'), `billing_address`) WHERE `gst_number` = '27CBOPS2386E1Z6';
UPDATE `customers` SET `pincode` = '400001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400001'), `billing_address`) WHERE `gst_number` = '27AQQPB0284R1Z8';
UPDATE `customers` SET `pincode` = '600001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 600001'), `billing_address`) WHERE `gst_number` = '33AGNPR1175J1Z3';
UPDATE `customers` SET `pincode` = '110005', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110005'), `billing_address`) WHERE `gst_number` = '07ACJPN4392F1ZE';
UPDATE `customers` SET `pincode` = '144003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144003'), `billing_address`) WHERE `gst_number` = '03AASFG4751E1ZG';
UPDATE `customers` SET `pincode` = '700073', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 700073'), `billing_address`) WHERE `gst_number` = '19AIHPA9031C1ZN';
UPDATE `customers` SET `pincode` = '360004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360004'), `billing_address`) WHERE `gst_number` = '24AAPFG1880P1ZS';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27BBQPK2600C1Z0';
UPDATE `customers` SET `pincode` = '395003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 395003'), `billing_address`) WHERE `gst_number` = '24HDAPS0949J1Z9';
UPDATE `customers` SET `pincode` = '363020', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 363020'), `billing_address`) WHERE `id` = 236;
UPDATE `customers` SET `pincode` = '416004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 416004'), `billing_address`) WHERE `gst_number` = '27AAAGG0710N1ZK';
UPDATE `customers` SET `pincode` = '144002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144002'), `billing_address`) WHERE `gst_number` = '03AAECG4904C1Z9';
UPDATE `customers` SET `pincode` = '401202', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401202'), `billing_address`) WHERE `gst_number` = '27AIVPD9608E1ZY';
UPDATE `customers` SET `pincode` = '246762', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 246762'), `billing_address`) WHERE `gst_number` = '09AQJPA0520C1ZM';
UPDATE `customers` SET `pincode` = '390018', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 390018'), `billing_address`) WHERE `gst_number` = '24AAFFG8339R1ZQ';
UPDATE `customers` SET `pincode` = '401105', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401105'), `billing_address`) WHERE `gst_number` = '27ANGPG9807N1ZG';
UPDATE `customers` SET `pincode` = '302003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 302003'), `billing_address`) WHERE `gst_number` = '08AQIPB0430H1ZD';
UPDATE `customers` SET `pincode` = '360004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360004'), `billing_address`) WHERE `gst_number` = '24AHGPS8329H1Z1';
UPDATE `customers` SET `pincode` = '560002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 560002'), `billing_address`) WHERE `gst_number` = '29AQMPA5016A1ZC';
UPDATE `customers` SET `pincode` = '600001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 600001'), `billing_address`) WHERE `gst_number` = '33ABRPD6918J1ZE';
UPDATE `customers` SET `pincode` = '440002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 440002'), `billing_address`) WHERE `gst_number` = '27AADFH0452L1ZF';
UPDATE `customers` SET `pincode` = '201001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 201001'), `billing_address`) WHERE `gst_number` = '09AADCH0641J1ZO';
UPDATE `customers` SET `pincode` = '421004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 421004'), `billing_address`) WHERE `gst_number` = '27ACKPS5274L1ZU';
UPDATE `customers` SET `pincode` = '421501', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 421501'), `billing_address`) WHERE `gst_number` = '27AOPPC4042R1ZG';
UPDATE `customers` SET `pincode` = '302022', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 302022'), `billing_address`) WHERE `gst_number` = '08ALFPA4794H1Z0';
UPDATE `customers` SET `pincode` = '360004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360004'), `billing_address`) WHERE `gst_number` = '24AHGPS8338E1Z6';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27ATMPS0604D1ZU';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AHOPD7937N1ZL';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AZFPM9518B1ZC';
UPDATE `customers` SET `pincode` = '400009', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400009'), `billing_address`) WHERE `gst_number` = '27AADPD0657K1ZT';
UPDATE `customers` SET `pincode` = '401101', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401101'), `billing_address`) WHERE `gst_number` = '27ACEPS2664Q1ZU';
UPDATE `customers` SET `pincode` = '400004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400004'), `billing_address`) WHERE `id` = 261;
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFH1138G1ZS';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27AAACH6616E1ZT';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AACPS2445R1Z3';
UPDATE `customers` SET `pincode` = '411003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 411003'), `billing_address`) WHERE `gst_number` = '27AADFH5130R1Z2';
UPDATE `customers` SET `pincode` = '400072', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400072'), `billing_address`) WHERE `gst_number` = '27AABPB1627P1ZR';
UPDATE `customers` SET `pincode` = '302029', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 302029'), `billing_address`) WHERE `gst_number` = '08ABLPD5048F1ZR';
UPDATE `customers` SET `pincode` = '400097', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400097'), `billing_address`) WHERE `gst_number` = '27BOKPS9447G1Z8';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27GFQPR8453R1ZY';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AABPR8541G1ZJ';
UPDATE `customers` SET `pincode` = '415639', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 415639'), `billing_address`) WHERE `gst_number` = '27AXJPM8849H1ZS';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAEFH7753B1ZH';
UPDATE `customers` SET `pincode` = '110064', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110064'), `billing_address`) WHERE `gst_number` = '07ABFPB2227C1ZG';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AOOPM3626E1ZU';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AGTPD5157C1ZD';
UPDATE `customers` SET `pincode` = '560002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 560002'), `billing_address`) WHERE `gst_number` = '29AERPA3084K1Z3';
UPDATE `customers` SET `pincode` = '302022', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 302022'), `billing_address`) WHERE `gst_number` = '08ALJPK0896N2ZD';
UPDATE `customers` SET `pincode` = '401305', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401305'), `billing_address`) WHERE `gst_number` = '27ADMPL5985E1Z2';
UPDATE `customers` SET `pincode` = '396195', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 396195'), `billing_address`) WHERE `gst_number` = '24AHUPB5004E1ZS';
UPDATE `customers` SET `pincode` = '400054', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400054'), `billing_address`) WHERE `gst_number` = '27DGWPK6358G1ZN';
UPDATE `customers` SET `pincode` = '400068', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400068'), `billing_address`) WHERE `gst_number` = '27BHMPS6265H1ZP';
UPDATE `customers` SET `pincode` = '400025', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400025'), `billing_address`) WHERE `gst_number` = '27AAAFI0671D1ZT';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFI1288C1ZO';
UPDATE `customers` SET `pincode` = '401202', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401202'), `billing_address`) WHERE `gst_number` = '27AACCI4406K1ZL';
UPDATE `customers` SET `pincode` = '400080', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400080'), `billing_address`) WHERE `gst_number` = '27AKSPP8497N1ZP';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27AGEPA6729Q1ZY';
UPDATE `customers` SET `pincode` = '400060', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400060'), `billing_address`) WHERE `gst_number` = '27FYQPS2547F1ZT';
UPDATE `customers` SET `pincode` = '400080', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400080'), `billing_address`) WHERE `gst_number` = '27AGLPS7868M1Z7';
UPDATE `customers` SET `pincode` = '302011', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 302011'), `billing_address`) WHERE `gst_number` = '08AGRPJ1122B1ZU';
UPDATE `customers` SET `pincode` = '400008', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400008'), `billing_address`) WHERE `id` = 299;
UPDATE `customers` SET `pincode` = '690502', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 690502'), `billing_address`) WHERE `gst_number` = '32AADFJ9716B1ZQ';
UPDATE `customers` SET `pincode` = '401107', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401107'), `billing_address`) WHERE `gst_number` = '27AADCJ1715D1Z0';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAOFJ1981H1ZZ';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AACFJ9009Q1ZT';
UPDATE `customers` SET `pincode` = '700073', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 700073'), `billing_address`) WHERE `gst_number` = '19AASFJ4550G1ZZ';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AALPM3622R1Z3';
UPDATE `customers` SET `pincode` = '360002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360002'), `billing_address`) WHERE `gst_number` = '24AVKPP5440L1Z8';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAOFJ7248P1ZE';
UPDATE `customers` SET `pincode` = '110037', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110037'), `billing_address`) WHERE `gst_number` = '07AADCJ5337K1ZD';
UPDATE `customers` SET `pincode` = '641001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 641001'), `billing_address`) WHERE `gst_number` = '33BCRPA9476Q1ZP';
UPDATE `customers` SET `pincode` = '400059', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400059'), `billing_address`) WHERE `gst_number` = '27AAFHA9004B1ZV';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AOJPS0324L1ZP';
UPDATE `customers` SET `pincode` = '401101', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401101'), `billing_address`) WHERE `gst_number` = '27AHNPK4479R1Z8';
UPDATE `customers` SET `pincode` = '361007', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 361007'), `billing_address`) WHERE `gst_number` = '24AAOPP1213G1ZZ';
UPDATE `customers` SET `pincode` = '400067', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400067'), `billing_address`) WHERE `gst_number` = '27AAIPS7704B1ZQ';
UPDATE `customers` SET `pincode` = '400070', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400070'), `billing_address`) WHERE `gst_number` = '27AAAFJ1549H1ZH';
UPDATE `customers` SET `pincode` = '400055', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400055'), `billing_address`) WHERE `gst_number` = '27AGAPM5144R1ZX';
UPDATE `customers` SET `pincode` = '400092', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400092'), `billing_address`) WHERE `gst_number` = '27AFFPD3249A1Z0';
UPDATE `customers` SET `pincode` = '342001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 342001'), `billing_address`) WHERE `gst_number` = '08ABVPS9540D1Z1';
UPDATE `customers` SET `pincode` = '400077', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400077'), `billing_address`) WHERE `gst_number` = '27ALGPM3471L1ZQ';
UPDATE `customers` SET `pincode` = '144021', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144021'), `billing_address`) WHERE `gst_number` = '03AASPM2601H1ZY';
UPDATE `customers` SET `pincode` = '400092', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400092'), `billing_address`) WHERE `gst_number` = '27AKFPD2078N2ZW';
UPDATE `customers` SET `pincode` = '400068', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400068'), `billing_address`) WHERE `gst_number` = '27AARFK3349R1ZC';
UPDATE `customers` SET `pincode` = '110028', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110028'), `billing_address`) WHERE `gst_number` = '07AOLPJ6544B1Z1';
UPDATE `customers` SET `pincode` = '500012', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 500012'), `billing_address`) WHERE `gst_number` = '36AANPP8675R1ZC';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFK7525L1Z3';
UPDATE `customers` SET `pincode` = '641001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 641001'), `billing_address`) WHERE `gst_number` = '33AACFK3989L1ZW';
UPDATE `customers` SET `pincode` = '401105', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401105'), `billing_address`) WHERE `gst_number` = '27APLPK2280E1ZX';
UPDATE `customers` SET `pincode` = '363641', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 363641'), `billing_address`) WHERE `gst_number` = '24CBSPV4538F1Z5';
UPDATE `customers` SET `pincode` = '400064', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400064'), `billing_address`) WHERE `gst_number` = '27AABPJ0149C1ZB';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AANFK5644H1ZZ';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27AALFK1282H1Z7';
UPDATE `customers` SET `pincode` = '400064', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400064'), `billing_address`) WHERE `gst_number` = '27ACWPK6333L1ZW';
UPDATE `customers` SET `pincode` = '452002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 452002'), `billing_address`) WHERE `gst_number` = '23AHMPK2598J1ZX';
UPDATE `customers` SET `pincode` = '360002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360002'), `billing_address`) WHERE `gst_number` = '24AAUFK5457D1Z3';
UPDATE `customers` SET `pincode` = '400701', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400701'), `billing_address`) WHERE `gst_number` = '27BIOPS1253C1Z8';
UPDATE `customers` SET `pincode` = '410203', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 410203'), `billing_address`) WHERE `gst_number` = '27AVGPC1792A1ZZ';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AACPS1384H1ZK';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AABPA0730G1ZH';
UPDATE `customers` SET `pincode` = '363641', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 363641'), `billing_address`) WHERE `gst_number` = '24AVHPT6190L1ZY';
UPDATE `customers` SET `pincode` = '396230', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 396230'), `billing_address`) WHERE `gst_number` = '26AAACK4226H1ZS';
UPDATE `customers` SET `pincode` = '605602', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 605602'), `billing_address`) WHERE `gst_number` = '33AFZPR5202H1Z6';
UPDATE `customers` SET `pincode` = '110052', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110052'), `billing_address`) WHERE `gst_number` = '07AAMPB1995P1Z3';
UPDATE `customers` SET `pincode` = '110039', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110039'), `billing_address`) WHERE `gst_number` = '07AGPPB4858A2ZI';
UPDATE `customers` SET `pincode` = '410206', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 410206'), `billing_address`) WHERE `gst_number` = '27BEIPS8282R1Z9';
UPDATE `customers` SET `pincode` = '360001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360001'), `billing_address`) WHERE `gst_number` = '24AAPPL0980R1ZZ';
UPDATE `customers` SET `pincode` = '360001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360001'), `billing_address`) WHERE `gst_number` = '24ABDPL5834H1ZR';
UPDATE `customers` SET `pincode` = '421301', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 421301'), `billing_address`) WHERE `gst_number` = '27AAIPT0929R1ZV';
UPDATE `customers` SET `pincode` = '700001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 700001'), `billing_address`) WHERE `gst_number` = '19ADRPB3177H1ZA';
UPDATE `customers` SET `pincode` = '360002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360002'), `billing_address`) WHERE `gst_number` = '24AQCPS4975N1Z5';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27AAAFL1366N1Z3';
UPDATE `customers` SET `pincode` = '700010', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 700010'), `billing_address`) WHERE `gst_number` = '19ATDPD8854D1ZN';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AKSPG0407H1Z9';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AACFL2179F1ZD';
UPDATE `customers` SET `pincode` = '144003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144003'), `billing_address`) WHERE `gst_number` = '03AJXPK9169L1ZA';
UPDATE `customers` SET `pincode` = '144002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144002'), `billing_address`) WHERE `gst_number` = '03ASRPK0002B1ZL';
UPDATE `customers` SET `pincode` = '400096', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400096'), `billing_address`) WHERE `gst_number` = '27AAGCI6554C1ZL';
UPDATE `customers` SET `pincode` = '360001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360001'), `billing_address`) WHERE `gst_number` = '24BBLPS2585K1Z2';
UPDATE `customers` SET `pincode` = '641001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 641001'), `billing_address`) WHERE `gst_number` = '33AVHPB6789P1ZW';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27AJNPB5174E1Z9';
UPDATE `customers` SET `pincode` = '400004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400004'), `billing_address`) WHERE `gst_number` = '27AYJPG0067C2ZR';
UPDATE `customers` SET `pincode` = '400015', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400015'), `billing_address`) WHERE `gst_number` = '27BVZPJ6622C2Z8';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27ABFFM3420L1Z8';
UPDATE `customers` SET `pincode` = '360004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360004'), `billing_address`) WHERE `gst_number` = '24AKCPC9963C1ZE';
UPDATE `customers` SET `pincode` = '400096', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400096'), `billing_address`) WHERE `gst_number` = '27AAJHR6539Q1Z5';
UPDATE `customers` SET `pincode` = '380001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 380001'), `billing_address`) WHERE `gst_number` = '24ASUPM8571A1ZG';
UPDATE `customers` SET `pincode` = '641001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 641001'), `billing_address`) WHERE `gst_number` = '33AIYPJ4171D2Z5';
UPDATE `customers` SET `pincode` = '382350', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 382350'), `billing_address`) WHERE `gst_number` = '24AIPPR7971J1ZF';
UPDATE `customers` SET `pincode` = '682031', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 682031'), `billing_address`) WHERE `gst_number` = '32AKZPP2560R2Z6';
UPDATE `customers` SET `pincode` = '400067', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400067'), `billing_address`) WHERE `gst_number` = '27BEYPM1253E1Z9';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27CFLPG8090Q1ZJ';
UPDATE `customers` SET `pincode` = '400004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400004'), `billing_address`) WHERE `gst_number` = '27AAHFM5319F1ZB';
UPDATE `customers` SET `pincode` = '401105', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401105'), `billing_address`) WHERE `gst_number` = '27BAMPP9552K1ZV';
UPDATE `customers` SET `pincode` = '421312', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 421312'), `billing_address`) WHERE `gst_number` = '27ADGPR7453R1ZK';
UPDATE `customers` SET `pincode` = '400007', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400007'), `billing_address`) WHERE `gst_number` = '27AATPR2132B1ZS';
UPDATE `customers` SET `pincode` = '400093', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400093'), `billing_address`) WHERE `gst_number` = '27AAFCM5904R1ZV';
UPDATE `customers` SET `pincode` = '400093', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400093'), `billing_address`) WHERE `gst_number` = '27AEBPD8476L1Z4';
UPDATE `customers` SET `pincode` = '110035', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110035'), `billing_address`) WHERE `gst_number` = '07AANCM5528M1ZV';
UPDATE `customers` SET `pincode` = '400001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400001'), `billing_address`) WHERE `gst_number` = '27AACPB3160A1ZL';
UPDATE `customers` SET `pincode` = '400086', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400086'), `billing_address`) WHERE `gst_number` = '27AFHPM2946M1ZY';
UPDATE `customers` SET `pincode` = '401101', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401101'), `billing_address`) WHERE `gst_number` = '27AEMPM8065M1ZP';
UPDATE `customers` SET `pincode` = '400092', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400092'), `billing_address`) WHERE `gst_number` = '27AHHPG2776P1ZQ';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AEYPP4023Q1ZK';
UPDATE `customers` SET `pincode` = '400086', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400086'), `billing_address`) WHERE `gst_number` = '27AAEPM2638Q1Z6';
UPDATE `customers` SET `pincode` = '401208', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401208'), `billing_address`) WHERE `gst_number` = '27AHYPB8704F1Z3';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27ABJPJ7385F1ZB';
UPDATE `customers` SET `pincode` = '400050', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400050'), `billing_address`) WHERE `gst_number` = '27ABDFM5002C1ZV';
UPDATE `customers` SET `pincode` = '454775', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 454775'), `billing_address`) WHERE `gst_number` = '23AAICM9813G1ZF';
UPDATE `customers` SET `pincode` = '250002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 250002'), `billing_address`) WHERE `gst_number` = '09AASPM7868A1Z5';
UPDATE `customers` SET `pincode` = '421201', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 421201'), `billing_address`) WHERE `gst_number` = '27AFEPG7343D1ZP';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27CGNPS0595K1ZL';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27BQGPS2242M1ZG';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AACFM0148B1ZV';
UPDATE `customers` SET `pincode` = '400009', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400009'), `billing_address`) WHERE `gst_number` = '27AAAPU5816G1ZL';
UPDATE `customers` SET `pincode` = '560002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 560002'), `billing_address`) WHERE `gst_number` = '29AALFM5210H1Z9';
UPDATE `customers` SET `pincode` = '400009', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400009'), `billing_address`) WHERE `gst_number` = '27AAAPU6305Q1Z6';
UPDATE `customers` SET `pincode` = '147001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 147001'), `billing_address`) WHERE `gst_number` = '03CLQPS7959P1ZT';
UPDATE `customers` SET `pincode` = '411002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 411002'), `billing_address`) WHERE `gst_number` = '27AAPFM2117B1ZL';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27ABCFM6618F1ZA';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFM9942R1ZG';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFM1588M1ZW';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AABFM0050D1ZZ';
UPDATE `customers` SET `pincode` = '400064', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400064'), `billing_address`) WHERE `gst_number` = '27AAACM3174G1ZL';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AABPK7330G1ZX';
UPDATE `customers` SET `pincode` = '400036', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400036'), `billing_address`) WHERE `gst_number` = '27AAAFM3647B1ZN';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAZPS0402R1ZV';
UPDATE `customers` SET `pincode` = '422001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 422001'), `billing_address`) WHERE `gst_number` = '27ARVPM0860A1ZR';
UPDATE `customers` SET `pincode` = '110002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110002'), `billing_address`) WHERE `gst_number` = '07ADEPR5516K1ZA';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AEFPJ1253B1Z2';
UPDATE `customers` SET `pincode` = '400080', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400080'), `billing_address`) WHERE `gst_number` = '27ANHPS7740R1ZZ';
UPDATE `customers` SET `pincode` = '560002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 560002'), `billing_address`) WHERE `gst_number` = '29BHYPC7217H1ZV';
UPDATE `customers` SET `pincode` = '400084', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400084'), `billing_address`) WHERE `gst_number` = '27AFVPN0656H1ZZ';
UPDATE `customers` SET `pincode` = '400080', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400080'), `billing_address`) WHERE `gst_number` = '27AAGPM9844A1ZN';
UPDATE `customers` SET `pincode` = '302033', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 302033'), `billing_address`) WHERE `gst_number` = '08ABAFM4310J1ZI';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27ANAPT0287D1Z2';
UPDATE `customers` SET `pincode` = '400064', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400064'), `billing_address`) WHERE `gst_number` = '27AVKPS3032K2Z8';
UPDATE `customers` SET `pincode` = '360001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360001'), `billing_address`) WHERE `gst_number` = '24AQSPS8111L1Z9';
UPDATE `customers` SET `pincode` = '600021', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 600021'), `billing_address`) WHERE `id` = 454;
UPDATE `customers` SET `pincode` = '400066', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400066'), `billing_address`) WHERE `gst_number` = '27AAGPS5572H1ZA';
UPDATE `customers` SET `pincode` = '110006', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110006'), `billing_address`) WHERE `gst_number` = '07BBIPS5626J2Z6';
UPDATE `customers` SET `pincode` = '140002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 140002'), `billing_address`) WHERE `gst_number` = '03AAAFN7394Q1ZP';
UPDATE `customers` SET `pincode` = '401107', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401107'), `billing_address`) WHERE `gst_number` = '27ACBPS6235L1Z8';
UPDATE `customers` SET `pincode` = '421302', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 421302'), `billing_address`) WHERE `gst_number` = '27ADIPG3455E1ZQ';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27AAAFN3943P1ZU';
UPDATE `customers` SET `pincode` = '400015', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400015'), `billing_address`) WHERE `gst_number` = '27ACPPM8827J2ZT';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AABPM3617N1ZI';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAOPS5854L1ZS';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAEPS2869P1ZT';
UPDATE `customers` SET `pincode` = '400075', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400075'), `billing_address`) WHERE `gst_number` = '27ACIPT2887L1ZQ';
UPDATE `customers` SET `pincode` = '401107', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401107'), `billing_address`) WHERE `gst_number` = '27AQOPS7443R1ZM';
UPDATE `customers` SET `pincode` = '600079', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 600079'), `billing_address`) WHERE `gst_number` = '33ACVPB6780D2ZI';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AALFM4268K1ZQ';
UPDATE `customers` SET `pincode` = '600003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 600003'), `billing_address`) WHERE `gst_number` = '33AAFPI8040R1ZE';
UPDATE `customers` SET `pincode` = '620008', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 620008'), `billing_address`) WHERE `gst_number` = '33AAJPU6108J1ZH';
UPDATE `customers` SET `pincode` = '363641', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 363641'), `billing_address`) WHERE `gst_number` = '24AFHPS6549A2ZF';
UPDATE `customers` SET `pincode` = '400020', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400020'), `billing_address`) WHERE `gst_number` = '27AABCN0991K1Z7';
UPDATE `customers` SET `pincode` = '360004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360004'), `billing_address`) WHERE `gst_number` = '24ARUPV1822G1ZH';
UPDATE `customers` SET `pincode` = '363641', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 363641'), `billing_address`) WHERE `gst_number` = '24BSSPV7069P1ZE';
UPDATE `customers` SET `pincode` = '363641', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 363641'), `billing_address`) WHERE `gst_number` = '24ABUPV1922B1ZN';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAEPS6458E1ZF';
UPDATE `customers` SET `pincode` = '400101', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400101'), `billing_address`) WHERE `gst_number` = '27ALGPM3548J1ZS';
UPDATE `customers` SET `pincode` = '370001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 370001'), `billing_address`) WHERE `gst_number` = '24AAIPH3467J1ZM';
UPDATE `customers` SET `pincode` = '246762', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 246762'), `billing_address`) WHERE `gst_number` = '09AGEPA3442N1ZE';
UPDATE `customers` SET `pincode` = '362001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 362001'), `billing_address`) WHERE `gst_number` = '24DCUPS5909F1Z2';
UPDATE `customers` SET `pincode` = '110041', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110041'), `billing_address`) WHERE `gst_number` = '07BSEPG1851N1ZL';
UPDATE `customers` SET `pincode` = '401202', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401202'), `billing_address`) WHERE `gst_number` = '27AMAPP4930E1Z8';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AXHPS0614G1ZJ';
UPDATE `customers` SET `pincode` = '360575', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360575'), `billing_address`) WHERE `gst_number` = '24AAAFO3358B1ZR';
UPDATE `customers` SET `pincode` = '641018', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 641018'), `billing_address`) WHERE `gst_number` = '33AAAFO4838Q1ZU';
UPDATE `customers` SET `pincode` = '431136', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 431136'), `billing_address`) WHERE `gst_number` = '27AAACL5555G1ZH';
UPDATE `customers` SET `pincode` = '400036', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400036'), `billing_address`) WHERE `gst_number` = '27ADEPD8513C1Z0';
UPDATE `customers` SET `pincode` = '400018', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400018'), `billing_address`) WHERE `gst_number` = '27AANFP5908M1ZK';
UPDATE `customers` SET `pincode` = '492001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 492001'), `billing_address`) WHERE `gst_number` = '22AAUFP1033A1ZS';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAPD7731P1ZH';
UPDATE `customers` SET `pincode` = '400092', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400092'), `billing_address`) WHERE `gst_number` = '27AACPR2497N1Z0';
UPDATE `customers` SET `pincode` = '144002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144002'), `billing_address`) WHERE `gst_number` = '03AAFFP4218A1ZY';
UPDATE `customers` SET `pincode` = '400092', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400092'), `billing_address`) WHERE `gst_number` = '27AAUPP4053E1ZF';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AHAPV9022A1ZK';
UPDATE `customers` SET `pincode` = '363421', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 363421'), `billing_address`) WHERE `gst_number` = '24AADHA5336E1ZU';
UPDATE `customers` SET `pincode` = '400102', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400102'), `billing_address`) WHERE `gst_number` = '27AJBPK4327L1Z4';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27AACHN3759B1ZB';
UPDATE `customers` SET `pincode` = '400080', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400080'), `billing_address`) WHERE `gst_number` = '27ABCFP2493H1Z2';
UPDATE `customers` SET `pincode` = '400097', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400097'), `billing_address`) WHERE `gst_number` = '27CECPS0781N1ZY';
UPDATE `customers` SET `pincode` = '411003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 411003'), `billing_address`) WHERE `gst_number` = '27AAIPN4131D1Z0';
UPDATE `customers` SET `pincode` = '400083', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400083'), `billing_address`) WHERE `gst_number` = '27AACFP2824M1Z2';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AEPPK1413G1ZN';
UPDATE `customers` SET `pincode` = '365009', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 365009'), `billing_address`) WHERE `gst_number` = '24AAOPT9718Q1ZK';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27AAEPS7083H1ZA';
UPDATE `customers` SET `pincode` = '400078', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400078'), `billing_address`) WHERE `gst_number` = '27AWGPS3863B1ZF';
UPDATE `customers` SET `pincode` = '421201', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 421201'), `billing_address`) WHERE `gst_number` = '27AGSPP5547P1Z9';
UPDATE `customers` SET `pincode` = '361006', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 361006'), `billing_address`) WHERE `gst_number` = '24CFIPP3099D1ZB';
UPDATE `customers` SET `pincode` = '400080', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400080'), `billing_address`) WHERE `gst_number` = '27AFZPS4171C1ZY';
UPDATE `customers` SET `pincode` = '560002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 560002'), `billing_address`) WHERE `gst_number` = '29AABFP8454C1Z6';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAFFP0808G1ZG';
UPDATE `customers` SET `pincode` = '400072', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400072'), `billing_address`) WHERE `id` = 527;
UPDATE `customers` SET `pincode` = '385001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 385001'), `billing_address`) WHERE `gst_number` = '24AAEPS8293F1ZE';
UPDATE `customers` SET `pincode` = '401202', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401202'), `billing_address`) WHERE `gst_number` = '27AAEPS8293F1Z8';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27AAAPV6621N1Z8';
UPDATE `customers` SET `pincode` = '400067', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400067'), `billing_address`) WHERE `gst_number` = '27AUPPS3859L1ZL';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AACPJ7408D1Z0';
UPDATE `customers` SET `pincode` = '400078', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400078'), `billing_address`) WHERE `gst_number` = '27BMKPP6143A1Z4';
UPDATE `customers` SET `pincode` = '416122', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 416122'), `billing_address`) WHERE `gst_number` = '27AAPFP4093H1ZR';
UPDATE `customers` SET `pincode` = '396210', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 396210'), `billing_address`) WHERE `gst_number` = '25AABCP3773B1ZQ';
UPDATE `customers` SET `pincode` = '641001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 641001'), `billing_address`) WHERE `gst_number` = '33ADXPJ2230K1ZF';
UPDATE `customers` SET `pincode` = '560002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 560002'), `billing_address`) WHERE `gst_number` = '29ABTPB5444M1Z2';
UPDATE `customers` SET `pincode` = '360024', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360024'), `billing_address`) WHERE `gst_number` = '24AELPB0575L1ZI';
UPDATE `customers` SET `pincode` = '144002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144002'), `billing_address`) WHERE `gst_number` = '03AANPB0297K1ZR';
UPDATE `customers` SET `pincode` = '400015', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400015'), `billing_address`) WHERE `gst_number` = '27AAJCP2423Q1ZY';
UPDATE `customers` SET `pincode` = '400027', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400027'), `billing_address`) WHERE `gst_number` = '27AAAFP2998Q1ZD';
UPDATE `customers` SET `pincode` = '401208', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401208'), `billing_address`) WHERE `gst_number` = '27AALHD8954M1ZI';
UPDATE `customers` SET `pincode` = '400086', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400086'), `billing_address`) WHERE `gst_number` = '27ABAPS7679C1ZC';
UPDATE `customers` SET `pincode` = '144002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144002'), `billing_address`) WHERE `gst_number` = '03AADFP0824A1Z4';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AACPD8168Q1Z4';
UPDATE `customers` SET `pincode` = '400080', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400080'), `billing_address`) WHERE `gst_number` = '27AAACP6182B1ZM';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27APLPM0185Q1Z6';
UPDATE `customers` SET `pincode` = '110084', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110084'), `billing_address`) WHERE `gst_number` = '07CSKPS7190F1Z7';
UPDATE `customers` SET `pincode` = '421201', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 421201'), `billing_address`) WHERE `gst_number` = '27BECPK0581B1ZY';
UPDATE `customers` SET `pincode` = '400710', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400710'), `billing_address`) WHERE `gst_number` = '27AACPB5028R1ZJ';
UPDATE `customers` SET `pincode` = '110007', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110007'), `billing_address`) WHERE `gst_number` = '07AAEPP1339H1ZS';
UPDATE `customers` SET `pincode` = '302001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 302001'), `billing_address`) WHERE `gst_number` = '08ASFPS6293L1ZX';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAEPM8705G1ZN';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAYPU0913C1ZH';
UPDATE `customers` SET `pincode` = '400054', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400054'), `billing_address`) WHERE `gst_number` = '27APNPK7359G1ZD';
UPDATE `customers` SET `pincode` = '492001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 492001'), `billing_address`) WHERE `gst_number` = '22BDUPS0314P2Z3';
UPDATE `customers` SET `pincode` = '400706', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400706'), `billing_address`) WHERE `gst_number` = '27ABLFR3871L1ZI';
UPDATE `customers` SET `pincode` = '110053', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110053'), `billing_address`) WHERE `gst_number` = '07AARPS4055Q1ZQ';
UPDATE `customers` SET `pincode` = '302003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 302003'), `billing_address`) WHERE `gst_number` = '08ACLPJ2711J1ZM';
UPDATE `customers` SET `pincode` = '400008', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400008'), `billing_address`) WHERE `gst_number` = '27AAAPH1029G1Z9';
UPDATE `customers` SET `pincode` = '110006', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110006'), `billing_address`) WHERE `gst_number` = '07AOZPS3965B1ZB';
UPDATE `customers` SET `pincode` = '400612', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400612'), `billing_address`) WHERE `gst_number` = '27AQUPM9775G1ZU';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AEAPM6387E1ZD';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAIFR3030K1Z6';
UPDATE `customers` SET `pincode` = '390006', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 390006'), `billing_address`) WHERE `gst_number` = '24AACFR0769D1ZH';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAPA8409R1ZF';
UPDATE `customers` SET `pincode` = '400009', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400009'), `billing_address`) WHERE `gst_number` = '27AAPPS1792L1ZU';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AADPS5610B1Z2';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAPFR9216A1Z4';
UPDATE `customers` SET `pincode` = '363641', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 363641'), `billing_address`) WHERE `gst_number` = '24AFHPS6550B2ZK';
UPDATE `customers` SET `pincode` = '144001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144001'), `billing_address`) WHERE `gst_number` = '03AAPFR6380R2ZB';
UPDATE `customers` SET `pincode` = '110039', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110039'), `billing_address`) WHERE `id` = 582;
UPDATE `customers` SET `pincode` = '400606', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400606'), `billing_address`) WHERE `gst_number` = '27AAFCR9525F1Z6';
UPDATE `customers` SET `pincode` = '380026', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 380026'), `billing_address`) WHERE `gst_number` = '24CONPN7759E1ZG';
UPDATE `customers` SET `pincode` = '110094', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110094'), `billing_address`) WHERE `gst_number` = '07ABAPW6112C1Z0';
UPDATE `customers` SET `pincode` = '143001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 143001'), `billing_address`) WHERE `gst_number` = '03CDQPR2195Q1ZN';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAFPS2666B1ZQ';
UPDATE `customers` SET `pincode` = '361007', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 361007'), `billing_address`) WHERE `gst_number` = '24ACTPM8280F1Z6';
UPDATE `customers` SET `pincode` = '110034', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110034'), `billing_address`) WHERE `gst_number` = '07AZNPB9236H1Z6';
UPDATE `customers` SET `pincode` = '144002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144002'), `billing_address`) WHERE `gst_number` = '03ABBFR3814K1ZD';
UPDATE `customers` SET `pincode` = '144002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144002'), `billing_address`) WHERE `gst_number` = '03AESPK4574M1ZX';
UPDATE `customers` SET `pincode` = '400013', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400013'), `billing_address`) WHERE `gst_number` = '27ACSPL0089L1ZY';
UPDATE `customers` SET `pincode` = '500002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 500002'), `billing_address`) WHERE `gst_number` = '36ACLPJ0742K1ZI';
UPDATE `customers` SET `pincode` = '700007', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 700007'), `billing_address`) WHERE `gst_number` = '19AXSPD4999E1ZS';
UPDATE `customers` SET `pincode` = '400093', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400093'), `billing_address`) WHERE `gst_number` = '27ABIPL1203H1Z1';
UPDATE `customers` SET `pincode` = '144040', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144040'), `billing_address`) WHERE `gst_number` = '03AAGFR8700G1ZG';
UPDATE `customers` SET `pincode` = '400093', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400093'), `billing_address`) WHERE `gst_number` = '27AAKFR7911D1Z5';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFR5720L1Z3';
UPDATE `customers` SET `pincode` = '400080', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400080'), `billing_address`) WHERE `gst_number` = '27AMQPB4613C1ZE';
UPDATE `customers` SET `pincode` = '400604', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400604'), `billing_address`) WHERE `gst_number` = '27AAKCR8240A1ZH';
UPDATE `customers` SET `pincode` = '600003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 600003'), `billing_address`) WHERE `gst_number` = '33AAFFR2197A1ZJ';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAKPG9240J1ZG';
UPDATE `customers` SET `pincode` = '340001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 340001'), `billing_address`) WHERE `gst_number` = '08ADKPS9437J1ZR';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAEFR0957M1ZS';
UPDATE `customers` SET `pincode` = '400604', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400604'), `billing_address`) WHERE `gst_number` = '27CBIPS9933H1ZZ';
UPDATE `customers` SET `pincode` = '560002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 560002'), `billing_address`) WHERE `gst_number` = '29BPHPM7716J1ZC';
UPDATE `customers` SET `pincode` = '400104', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400104'), `billing_address`) WHERE `gst_number` = '27AADPR4380D1ZQ';
UPDATE `customers` SET `pincode` = '400093', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400093'), `billing_address`) WHERE `gst_number` = '27AATFR4754P1Z4';
UPDATE `customers` SET `pincode` = '400093', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400093'), `billing_address`) WHERE `gst_number` = '27AAMCR3632E1ZD';
UPDATE `customers` SET `pincode` = '360001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360001'), `billing_address`) WHERE `gst_number` = '24AANFR4269B1Z7';
UPDATE `customers` SET `pincode` = '500002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 500002'), `billing_address`) WHERE `gst_number` = '36AAHHS4492P1Z9';
UPDATE `customers` SET `pincode` = '302020', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 302020'), `billing_address`) WHERE `gst_number` = '08AFVPG9791E1ZQ';
UPDATE `customers` SET `pincode` = '401101', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401101'), `billing_address`) WHERE `gst_number` = '27AHYPM5666R1ZW';
UPDATE `customers` SET `pincode` = '122001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 122001'), `billing_address`) WHERE `gst_number` = '06ALNPB6505F1ZE';
UPDATE `customers` SET `pincode` = '341001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 341001'), `billing_address`) WHERE `gst_number` = '08ABJPS6891H1ZX';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AACHB7612P1Z2';
UPDATE `customers` SET `pincode` = '400068', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400068'), `billing_address`) WHERE `gst_number` = '27ABRFS6636A1ZX';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27ADVPI6312H1ZB';
UPDATE `customers` SET `pincode` = '400013', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400013'), `billing_address`) WHERE `gst_number` = '27AAPCS0080A1ZL';
UPDATE `customers` SET `pincode` = '401208', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401208'), `billing_address`) WHERE `gst_number` = '27ARYPS9919D1ZU';
UPDATE `customers` SET `pincode` = '360002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360002'), `billing_address`) WHERE `gst_number` = '24NAWPS8295G1ZF';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27AAPFS9968Q1ZN';
UPDATE `customers` SET `pincode` = '401208', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401208'), `billing_address`) WHERE `gst_number` = '27OXVPS3277P1ZR';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAYPS3747A1Z9';
UPDATE `customers` SET `pincode` = '401105', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401105'), `billing_address`) WHERE `gst_number` = '27AJYPS1821Q1Z6';
UPDATE `customers` SET `pincode` = '400064', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400064'), `billing_address`) WHERE `gst_number` = '27APVPJ3273Q1ZW';
UPDATE `customers` SET `pincode` = '400018', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400018'), `billing_address`) WHERE `gst_number` = '27ACWPD5101F1ZS';
UPDATE `customers` SET `pincode` = '400009', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400009'), `billing_address`) WHERE `gst_number` = '27AACFS4886L1ZJ';
UPDATE `customers` SET `pincode` = '422001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 422001'), `billing_address`) WHERE `gst_number` = '27AGOPM6609B1ZC';
UPDATE `customers` SET `pincode` = '361004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 361004'), `billing_address`) WHERE `gst_number` = '24AEOFS3355J1ZN';
UPDATE `customers` SET `pincode` = '400705', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400705'), `billing_address`) WHERE `gst_number` = '27AAACS5624F1ZI';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27ABHPY6626Q1ZL';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AGZPA4933H1Z2';
UPDATE `customers` SET `pincode` = '400067', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400067'), `billing_address`) WHERE `gst_number` = '27ALVPS7815D1ZI';
UPDATE `customers` SET `pincode` = '400051', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400051'), `billing_address`) WHERE `gst_number` = '27AAWPM9338D1Z4';
UPDATE `customers` SET `pincode` = '401101', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401101'), `billing_address`) WHERE `gst_number` = '27ACEPM8226E1ZN';
UPDATE `customers` SET `pincode` = '400058', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400058'), `billing_address`) WHERE `gst_number` = '27AAWPM9225D1ZA';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27APAPS5419L1ZI';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFS0564P1ZU';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAMFS3625D1Z7';
UPDATE `customers` SET `pincode` = '401303', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401303'), `billing_address`) WHERE `id` = 656;
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AACFS4404J1Z9';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAACS7143P1ZV';
UPDATE `customers` SET `pincode` = '700073', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 700073'), `billing_address`) WHERE `id` = 660;
UPDATE `customers` SET `pincode` = '363641', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 363641'), `billing_address`) WHERE `gst_number` = '24AFHPS6552D1ZF';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27ADPFS6863H1ZC';
UPDATE `customers` SET `pincode` = '400004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400004'), `billing_address`) WHERE `gst_number` = '27AALFS9545H1ZL';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFS1134M1Z8';
UPDATE `customers` SET `pincode` = '110006', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110006'), `billing_address`) WHERE `gst_number` = '07AAOPI2470E1ZT';
UPDATE `customers` SET `pincode` = '400001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400001'), `billing_address`) WHERE `gst_number` = '27ADPFS9020E1ZV';
UPDATE `customers` SET `pincode` = '400080', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400080'), `billing_address`) WHERE `gst_number` = '27AFBPG8815M1Z6';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AADHK2099E1Z8';
UPDATE `customers` SET `pincode` = '400013', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400013'), `billing_address`) WHERE `gst_number` = '27ACVFS3662B1ZT';
UPDATE `customers` SET `pincode` = '422010', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 422010'), `billing_address`) WHERE `gst_number` = '27AJRPK2357E1Z1';
UPDATE `customers` SET `pincode` = '302018', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 302018'), `billing_address`) WHERE `gst_number` = '08COOPG7914R1Z0';
UPDATE `customers` SET `pincode` = '400101', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400101'), `billing_address`) WHERE `gst_number` = '27ALJPV6432H1ZO';
UPDATE `customers` SET `pincode` = '400043', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400043'), `billing_address`) WHERE `gst_number` = '27CYCPP0669N1ZT';
UPDATE `customers` SET `pincode` = '302022', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 302022'), `billing_address`) WHERE `gst_number` = '08AJEPJ2947E1ZB';
UPDATE `customers` SET `pincode` = '400093', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400093'), `billing_address`) WHERE `gst_number` = '27AGHPC1080B1Z2';
UPDATE `customers` SET `pincode` = '360003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360003'), `billing_address`) WHERE `gst_number` = '24AFFPV3896M1ZM';
UPDATE `customers` SET `pincode` = '400092', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400092'), `billing_address`) WHERE `gst_number` = '27AKEPM1013F1ZP';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27ACFPK3175R1ZZ';
UPDATE `customers` SET `pincode` = '382210', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 382210'), `billing_address`) WHERE `gst_number` = '24DILPS9326F1ZV';
UPDATE `customers` SET `pincode` = '400017', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400017'), `billing_address`) WHERE `gst_number` = '27ASNPP1185G1ZE';
UPDATE `customers` SET `pincode` = '110053', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110053'), `billing_address`) WHERE `gst_number` = '07CETPM8809J1ZO';
UPDATE `customers` SET `pincode` = '380024', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 380024'), `billing_address`) WHERE `gst_number` = '24AFCPC8100Q1ZL';
UPDATE `customers` SET `pincode` = '382415', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 382415'), `billing_address`) WHERE `gst_number` = '24ADWPT9639D1ZT';
UPDATE `customers` SET `pincode` = '360001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360001'), `billing_address`) WHERE `gst_number` = '24AADHS7040F1ZD';
UPDATE `customers` SET `pincode` = '361004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 361004'), `billing_address`) WHERE `gst_number` = '24ADYPD2827P1ZY';
UPDATE `customers` SET `pincode` = '400618', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400618'), `billing_address`) WHERE `gst_number` = '27ADUFS1722Q1Z8';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27AALFS2322Q1ZP';
UPDATE `customers` SET `pincode` = '110032', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110032'), `billing_address`) WHERE `gst_number` = '07AACFS1123J1ZH';
UPDATE `customers` SET `pincode` = '400093', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400093'), `billing_address`) WHERE `gst_number` = '27ATZPB4256F1ZE';
UPDATE `customers` SET `pincode` = '400028', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400028'), `billing_address`) WHERE `gst_number` = '27AZCPS4138E1ZD';
UPDATE `customers` SET `pincode` = '144002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144002'), `billing_address`) WHERE `gst_number` = '03AZKPG4759K1Z3';
UPDATE `customers` SET `pincode` = '400001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400001'), `billing_address`) WHERE `gst_number` = '27AAUCS4161M1ZL';
UPDATE `customers` SET `pincode` = '300302', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 300302'), `billing_address`) WHERE `gst_number` = '08EKTPK5149D1ZR';
UPDATE `customers` SET `pincode` = '380001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 380001'), `billing_address`) WHERE `gst_number` = '24AFMPP2691D2ZC';
UPDATE `customers` SET `pincode` = '395003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 395003'), `billing_address`) WHERE `gst_number` = '24BLFPG9968Q1Z6';
UPDATE `customers` SET `pincode` = '395003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 395003'), `billing_address`) WHERE `gst_number` = '24AEQPB8546L1Z2';
UPDATE `customers` SET `pincode` = '400092', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400092'), `billing_address`) WHERE `gst_number` = '27AJDPB9024B1ZS';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AELFS0854F1ZV';
UPDATE `customers` SET `pincode` = '396445', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 396445'), `billing_address`) WHERE `id` = 716;
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFS7672J1ZR';
UPDATE `customers` SET `pincode` = '395003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 395003'), `billing_address`) WHERE `gst_number` = '24AEDPS0610P1ZH';
UPDATE `customers` SET `pincode` = '360001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360001'), `billing_address`) WHERE `gst_number` = '24AGBPS7204H1ZK';
UPDATE `customers` SET `pincode` = '396195', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 396195'), `billing_address`) WHERE `gst_number` = '24AAKPS3827M1Z7';
UPDATE `customers` SET `pincode` = '635126', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 635126'), `billing_address`) WHERE `gst_number` = '33CAWPM0887K1ZY';
UPDATE `customers` SET `pincode` = '600021', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 600021'), `billing_address`) WHERE `gst_number` = '33AEUPB6413Q1Z3';
UPDATE `customers` SET `pincode` = '133001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 133001'), `billing_address`) WHERE `gst_number` = '06AEYPP4952N1ZG';
UPDATE `customers` SET `pincode` = '302003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 302003'), `billing_address`) WHERE `gst_number` = '08AFGFS7033E1ZZ';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AACPS6675F1ZC';
UPDATE `customers` SET `pincode` = '641001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 641001'), `billing_address`) WHERE `gst_number` = '33ADEPM5850H1ZM';
UPDATE `customers` SET `pincode` = '605001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 605001'), `billing_address`) WHERE `gst_number` = '34AABTS0117KRZ0';
UPDATE `customers` SET `pincode` = '400016', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400016'), `billing_address`) WHERE `gst_number` = '27AAIPM2997G1Z9';
UPDATE `customers` SET `pincode` = '500002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 500002'), `billing_address`) WHERE `gst_number` = '36AHCPP3350K1Z9';
UPDATE `customers` SET `pincode` = '500003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 500003'), `billing_address`) WHERE `gst_number` = '36ARVPP5165H1Z3';
UPDATE `customers` SET `pincode` = '360003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360003'), `billing_address`) WHERE `gst_number` = '24AEGFS1299M1ZI';
UPDATE `customers` SET `pincode` = '360002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360002'), `billing_address`) WHERE `gst_number` = '24AMDPM0010B1Z5';
UPDATE `customers` SET `pincode` = '600003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 600003'), `billing_address`) WHERE `gst_number` = '33AFCPJ0713N1ZQ';
UPDATE `customers` SET `pincode` = '520001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 520001'), `billing_address`) WHERE `gst_number` = '37ASKPD6181F1ZO';
UPDATE `customers` SET `pincode` = '302003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 302003'), `billing_address`) WHERE `gst_number` = '08AGNPJ7861K1ZP';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27ACPPM8416K1ZZ';
UPDATE `customers` SET `pincode` = '110063', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110063'), `billing_address`) WHERE `gst_number` = '07CKTPS5015G1ZS';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `id` = 740;
UPDATE `customers` SET `pincode` = '400004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400004'), `billing_address`) WHERE `id` = 741;
UPDATE `customers` SET `pincode` = '400004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400004'), `billing_address`) WHERE `gst_number` = '27AFTPC5556M1ZS';
UPDATE `customers` SET `pincode` = '110055', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110055'), `billing_address`) WHERE `gst_number` = '07CZXPD6242H1Z0';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27ALWPS1407J1ZK';
UPDATE `customers` SET `pincode` = '600001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 600001'), `billing_address`) WHERE `gst_number` = '33AAYFS4619K1ZJ';
UPDATE `customers` SET `pincode` = '400102', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400102'), `billing_address`) WHERE `gst_number` = '27AYBPP8248E1Z8';
UPDATE `customers` SET `pincode` = '144002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144002'), `billing_address`) WHERE `gst_number` = '03ABNCS2052D1ZP';
UPDATE `customers` SET `pincode` = '110088', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110088'), `billing_address`) WHERE `gst_number` = '07AANPK4424H1ZO';
UPDATE `customers` SET `pincode` = '695036', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 695036'), `billing_address`) WHERE `gst_number` = '32AARFS7048F1ZY';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27AAAPM6811H1ZU';
UPDATE `customers` SET `pincode` = '641001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 641001'), `billing_address`) WHERE `gst_number` = '33AAPFS5494M1ZD';
UPDATE `customers` SET `pincode` = '401105', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401105'), `billing_address`) WHERE `gst_number` = '27AQEPM4901E1Z4';
UPDATE `customers` SET `pincode` = '302019', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 302019'), `billing_address`) WHERE `gst_number` = '08AJAPC4799F1Z6';
UPDATE `customers` SET `pincode` = '110039', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110039'), `billing_address`) WHERE `gst_number` = '07AAIPB4716E1Z5';
UPDATE `customers` SET `pincode` = '401101', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401101'), `billing_address`) WHERE `gst_number` = '27DDZPP9203H1ZT';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27CZZPG4990B1ZU';
UPDATE `customers` SET `pincode` = '400086', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400086'), `billing_address`) WHERE `gst_number` = '27AAEPS2001D1ZA';
UPDATE `customers` SET `pincode` = '400070', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400070'), `billing_address`) WHERE `gst_number` = '27AACPG8089M1Z5';
UPDATE `customers` SET `pincode` = '144002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144002'), `billing_address`) WHERE `gst_number` = '03AIVPK7936J1ZN';
UPDATE `customers` SET `pincode` = '144002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 144002'), `billing_address`) WHERE `gst_number` = '03AAECS7037A1ZV';
UPDATE `customers` SET `pincode` = '395003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 395003'), `billing_address`) WHERE `gst_number` = '24ADZFS9251P1ZV';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27BHTPS1660M1ZI';
UPDATE `customers` SET `pincode` = '400002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400002'), `billing_address`) WHERE `gst_number` = '27AADPM6625N1ZA';
UPDATE `customers` SET `pincode` = '401209', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401209'), `billing_address`) WHERE `gst_number` = '27AFGPY0145M3ZY';
UPDATE `customers` SET `pincode` = '334001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 334001'), `billing_address`) WHERE `gst_number` = '08ADTPS8358R1Z0';
UPDATE `customers` SET `pincode` = '474001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 474001'), `billing_address`) WHERE `gst_number` = '23BQOPR4748H1ZD';
UPDATE `customers` SET `pincode` = '676552', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 676552'), `billing_address`) WHERE `gst_number` = '32AFHPR5818R1ZR';
UPDATE `customers` SET `pincode` = '400059', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400059'), `billing_address`) WHERE `gst_number` = '27AWGPS3489K1ZQ';
UPDATE `customers` SET `pincode` = '625001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 625001'), `billing_address`) WHERE `gst_number` = '33AAZPN3194R1ZK';
UPDATE `customers` SET `pincode` = '400012', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400012'), `billing_address`) WHERE `gst_number` = '27ACHFS9103K1ZS';
UPDATE `customers` SET `pincode` = '422007', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 422007'), `billing_address`) WHERE `gst_number` = '27AADFT1582H1Z3';
UPDATE `customers` SET `pincode` = '560095', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 560095'), `billing_address`) WHERE `gst_number` = '29AACCT3705E1ZJ';
UPDATE `customers` SET `pincode` = '400067', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400067'), `billing_address`) WHERE `gst_number` = '27AAIHJ7892P1Z6';
UPDATE `customers` SET `pincode` = '400604', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400604'), `billing_address`) WHERE `gst_number` = '27AADCT3346E1ZH';
UPDATE `customers` SET `pincode` = '600108', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 600108'), `billing_address`) WHERE `gst_number` = '33AACFT2457N1ZY';
UPDATE `customers` SET `pincode` = '400104', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400104'), `billing_address`) WHERE `gst_number` = '27AAAPF0646H1Z4';
UPDATE `customers` SET `pincode` = '400004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400004'), `billing_address`) WHERE `gst_number` = '27BRQPS4005P1Z1';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAMPS5006Q1Z0';
UPDATE `customers` SET `pincode` = '500001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 500001'), `billing_address`) WHERE `gst_number` = '36AFMPJ1286Q1ZQ';
UPDATE `customers` SET `pincode` = '360002', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360002'), `billing_address`) WHERE `gst_number` = '24AANFT0554D1ZD';
UPDATE `customers` SET `pincode` = '363641', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 363641'), `billing_address`) WHERE `gst_number` = '24AFNPS7255P1ZI';
UPDATE `customers` SET `pincode` = '110006', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110006'), `billing_address`) WHERE `gst_number` = '07AAFPG4432M1ZP';
UPDATE `customers` SET `pincode` = '110006', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110006'), `billing_address`) WHERE `gst_number` = '07ACGPB3104J1Z4';
UPDATE `customers` SET `pincode` = '625528', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 625528'), `billing_address`) WHERE `gst_number` = '33AKHPR8139C1Z5';
UPDATE `customers` SET `pincode` = '474001', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 474001'), `billing_address`) WHERE `gst_number` = '23BBAPM1792F1ZX';
UPDATE `customers` SET `pincode` = '400011', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400011'), `billing_address`) WHERE `gst_number` = '27ABQPH7607D2ZK';
UPDATE `customers` SET `pincode` = '400705', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400705'), `billing_address`) WHERE `gst_number` = '27AAECT5753C1ZD';
UPDATE `customers` SET `pincode` = '361004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 361004'), `billing_address`) WHERE `gst_number` = '24ACFPG4426R1ZD';
UPDATE `customers` SET `pincode` = '400064', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400064'), `billing_address`) WHERE `gst_number` = '27AANHS8328C1ZU';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AJQPG3512L1Z0';
UPDATE `customers` SET `pincode` = '625513', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 625513'), `billing_address`) WHERE `gst_number` = '33AZRPS8946B1ZV';
UPDATE `customers` SET `pincode` = '110062', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110062'), `billing_address`) WHERE `gst_number` = '07ATVPJ8645A1ZD';
UPDATE `customers` SET `pincode` = '400037', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400037'), `billing_address`) WHERE `gst_number` = '27AYXPS2841J1ZL';
UPDATE `customers` SET `pincode` = '400072', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400072'), `billing_address`) WHERE `gst_number` = '27AFFPJ7350A1ZS';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AUGPK7134F1ZN';
UPDATE `customers` SET `pincode` = '410206', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 410206'), `billing_address`) WHERE `id` = 809;
UPDATE `customers` SET `pincode` = '361004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 361004'), `billing_address`) WHERE `gst_number` = '24ABUPB3572F1ZP';
UPDATE `customers` SET `pincode` = '361004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 361004'), `billing_address`) WHERE `gst_number` = '24AACFU1500B1Z3';
UPDATE `customers` SET `pincode` = '400063', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400063'), `billing_address`) WHERE `gst_number` = '27AAAFU0755C1ZI';
UPDATE `customers` SET `pincode` = '400008', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400008'), `billing_address`) WHERE `gst_number` = '27ASJPR4862L1ZZ';
UPDATE `customers` SET `pincode` = '416216', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 416216'), `billing_address`) WHERE `gst_number` = '27AIPPG5415J1Z1';
UPDATE `customers` SET `pincode` = '360004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360004'), `billing_address`) WHERE `gst_number` = '24BEMPP0481B1ZQ';
UPDATE `customers` SET `pincode` = '380007', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 380007'), `billing_address`) WHERE `gst_number` = '24AVJPL5308E1ZT';
UPDATE `customers` SET `pincode` = '400018', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400018'), `billing_address`) WHERE `gst_number` = '27AAACU6722G1ZD';
UPDATE `customers` SET `pincode` = '400097', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400097'), `billing_address`) WHERE `gst_number` = '27AEEPM4586R1ZL';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AGSPD7593D1Z0';
UPDATE `customers` SET `pincode` = '400052', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400052'), `billing_address`) WHERE `gst_number` = '27AFPPV7502N1ZL';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFV5145M1ZU';
UPDATE `customers` SET `pincode` = '401209', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401209'), `billing_address`) WHERE `gst_number` = '27BNFPS9703P1Z5';
UPDATE `customers` SET `pincode` = '400093', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400093'), `billing_address`) WHERE `gst_number` = '27AACCV0184B1ZO';
UPDATE `customers` SET `pincode` = '400067', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400067'), `billing_address`) WHERE `gst_number` = '27AQVPS3030K1ZA';
UPDATE `customers` SET `pincode` = '360007', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 360007'), `billing_address`) WHERE `gst_number` = '24AMDPD1375J1ZB';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAWFV9674P1ZK';
UPDATE `customers` SET `pincode` = '600108', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 600108'), `billing_address`) WHERE `gst_number` = '33AAAFV0380L1Z8';
UPDATE `customers` SET `pincode` = '400068', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400068'), `billing_address`) WHERE `gst_number` = '27AFCPM5030K1ZI';
UPDATE `customers` SET `pincode` = '400004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400004'), `billing_address`) WHERE `gst_number` = '27AAHCV3778L1ZK';
UPDATE `customers` SET `pincode` = '400009', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400009'), `billing_address`) WHERE `gst_number` = '27AAEFV2253N1ZT';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27ANIPS6068B1ZS';
UPDATE `customers` SET `pincode` = '400080', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400080'), `billing_address`) WHERE `gst_number` = '27AAVPS0371F1ZC';
UPDATE `customers` SET `pincode` = '400080', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400080'), `billing_address`) WHERE `gst_number` = '27AAPPP8786K1ZJ';
UPDATE `customers` SET `pincode` = '400068', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400068'), `billing_address`) WHERE `gst_number` = '27AULPP8494L1ZJ';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27ANQPS6878M1ZN';
UPDATE `customers` SET `pincode` = '110009', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 110009'), `billing_address`) WHERE `gst_number` = '07ALLPD6213G1ZD';
UPDATE `customers` SET `pincode` = '400096', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400096'), `billing_address`) WHERE `gst_number` = '27AAACS6827Q1ZO';
UPDATE `customers` SET `pincode` = '361006', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 361006'), `billing_address`) WHERE `gst_number` = '24ACWPV8921B1Z6';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAJCV1465G1Z5';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAPM2223P1ZN';
UPDATE `customers` SET `pincode` = '625528', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 625528'), `billing_address`) WHERE `gst_number` = '33BREPR0462D1Z5';
UPDATE `customers` SET `pincode` = '416010', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 416010'), `billing_address`) WHERE `id` = 854;
UPDATE `customers` SET `pincode` = '400019', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400019'), `billing_address`) WHERE `gst_number` = '27AADPC0544J1Z2';
UPDATE `customers` SET `pincode` = '400080', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400080'), `billing_address`) WHERE `gst_number` = '27AAOPS1998K1ZP';
UPDATE `customers` SET `pincode` = '400072', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400072'), `billing_address`) WHERE `gst_number` = '27AAQPS7478C1Z1';
UPDATE `customers` SET `pincode` = '361004', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 361004'), `billing_address`) WHERE `gst_number` = '24BXBPB8139G1ZR';
UPDATE `customers` SET `pincode` = '440035', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 440035'), `billing_address`) WHERE `gst_number` = '27AIEPT3168Q1ZF';
UPDATE `customers` SET `pincode` = '400102', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400102'), `billing_address`) WHERE `gst_number` = '27AADCW3581C1ZD';
UPDATE `customers` SET `pincode` = '401201', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 401201'), `billing_address`) WHERE `gst_number` = '27ALZPA7408E1ZX';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAPZ0813E1ZX';
UPDATE `customers` SET `pincode` = '400067', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400067'), `billing_address`) WHERE `gst_number` = '27ACMPV3129P1ZR';
UPDATE `customers` SET `pincode` = '400028', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400028'), `billing_address`) WHERE `gst_number` = '27AAKPK3410E1Z3';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AFHPD0013N1ZR';
UPDATE `customers` SET `pincode` = '396195', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 396195'), `billing_address`) WHERE `gst_number` = '24EYKPP8934G1ZW';
UPDATE `customers` SET `pincode` = '400003', `billing_address` = IF(`billing_address` != '' AND `billing_address` IS NOT NULL, CONCAT(`billing_address`, ' - 400003'), `billing_address`) WHERE `gst_number` = '27AAAFY0134D1ZN';