UPDATE `ulkesehir` SET `ne` = 'E' WHERE `ust` = 'US';
UPDATE `ulkesehir` SET `ne` = 'S' WHERE `ne` = 'I' AND `ust` LIKE 'US%';
UPDATE `ulkesehir` SET `kod` = 'AL' WHERE `kod` = 'US001';
UPDATE `ulkesehir` SET `ust` = 'AL' WHERE `ust` = 'US001';
UPDATE `ulkesehir` SET `kod` = 'AK' WHERE `kod` = 'US002';
UPDATE `ulkesehir` SET `ust` = 'AK' WHERE `ust` = 'US002';
UPDATE `ulkesehir` SET `kod` = 'AZ' WHERE `kod` = 'US003';
UPDATE `ulkesehir` SET `ust` = 'AZ' WHERE `ust` = 'US003';
UPDATE `ulkesehir` SET `kod` = 'AR' WHERE `kod` = 'US004';
UPDATE `ulkesehir` SET `ust` = 'AR' WHERE `ust` = 'US004';
UPDATE `ulkesehir` SET `kod` = 'CA' WHERE `kod` = 'US006';
UPDATE `ulkesehir` SET `ust` = 'CA' WHERE `ust` = 'US006';
UPDATE `ulkesehir` SET `kod` = 'CO' WHERE `kod` = 'US008';
UPDATE `ulkesehir` SET `ust` = 'CO' WHERE `ust` = 'US008';
UPDATE `ulkesehir` SET `kod` = 'CT' WHERE `kod` = 'US009';
UPDATE `ulkesehir` SET `ust` = 'CT' WHERE `ust` = 'US009';
UPDATE `ulkesehir` SET `kod` = 'DE' WHERE `kod` = 'US010';
UPDATE `ulkesehir` SET `ust` = 'DE' WHERE `ust` = 'US010';
UPDATE `ulkesehir` SET `kod` = 'FL' WHERE `kod` = 'US012';
UPDATE `ulkesehir` SET `ust` = 'FL' WHERE `ust` = 'US012';
UPDATE `ulkesehir` SET `kod` = 'GA' WHERE `kod` = 'US013';
UPDATE `ulkesehir` SET `ust` = 'GA' WHERE `ust` = 'US013';
UPDATE `ulkesehir` SET `kod` = 'HI' WHERE `kod` = 'US014';
UPDATE `ulkesehir` SET `ust` = 'HI' WHERE `ust` = 'US014';
UPDATE `ulkesehir` SET `kod` = 'ID' WHERE `kod` = 'US015';
UPDATE `ulkesehir` SET `ust` = 'ID' WHERE `ust` = 'US015';
UPDATE `ulkesehir` SET `kod` = 'IL' WHERE `kod` = 'US016';
UPDATE `ulkesehir` SET `ust` = 'IL' WHERE `ust` = 'US016';
UPDATE `ulkesehir` SET `kod` = 'IN' WHERE `kod` = 'US017';
UPDATE `ulkesehir` SET `ust` = 'IN' WHERE `ust` = 'US017';
UPDATE `ulkesehir` SET `kod` = 'IA' WHERE `kod` = 'US018';
UPDATE `ulkesehir` SET `ust` = 'IA' WHERE `ust` = 'US018';
UPDATE `ulkesehir` SET `kod` = 'KS' WHERE `kod` = 'US019';
UPDATE `ulkesehir` SET `ust` = 'KS' WHERE `ust` = 'US019';
UPDATE `ulkesehir` SET `kod` = 'KY' WHERE `kod` = 'US020';
UPDATE `ulkesehir` SET `ust` = 'KY' WHERE `ust` = 'US020';
UPDATE `ulkesehir` SET `kod` = 'LA' WHERE `kod` = 'US021';
UPDATE `ulkesehir` SET `ust` = 'LA' WHERE `ust` = 'US021';
UPDATE `ulkesehir` SET `kod` = 'ME' WHERE `kod` = 'US023';
UPDATE `ulkesehir` SET `ust` = 'ME' WHERE `ust` = 'US023';
UPDATE `ulkesehir` SET `kod` = 'MD' WHERE `kod` = 'US024';
UPDATE `ulkesehir` SET `ust` = 'MD' WHERE `ust` = 'US024';
UPDATE `ulkesehir` SET `kod` = 'MA' WHERE `kod` = 'US025';
UPDATE `ulkesehir` SET `ust` = 'MA' WHERE `ust` = 'US025';
UPDATE `ulkesehir` SET `kod` = 'MI' WHERE `kod` = 'US027';
UPDATE `ulkesehir` SET `ust` = 'MI' WHERE `ust` = 'US027';
UPDATE `ulkesehir` SET `kod` = 'MN' WHERE `kod` = 'US028';
UPDATE `ulkesehir` SET `ust` = 'MN' WHERE `ust` = 'US028';
UPDATE `ulkesehir` SET `kod` = 'MS' WHERE `kod` = 'US029';
UPDATE `ulkesehir` SET `ust` = 'MS' WHERE `ust` = 'US029';
UPDATE `ulkesehir` SET `kod` = 'MO' WHERE `kod` = 'US030';
UPDATE `ulkesehir` SET `ust` = 'MO' WHERE `ust` = 'US030';
UPDATE `ulkesehir` SET `kod` = 'MT' WHERE `kod` = 'US031';
UPDATE `ulkesehir` SET `ust` = 'MT' WHERE `ust` = 'US031';
UPDATE `ulkesehir` SET `kod` = 'NE' WHERE `kod` = 'US032';
UPDATE `ulkesehir` SET `ust` = 'NE' WHERE `ust` = 'US032';
UPDATE `ulkesehir` SET `kod` = 'NV' WHERE `kod` = 'US033';
UPDATE `ulkesehir` SET `ust` = 'NV' WHERE `ust` = 'US033';
UPDATE `ulkesehir` SET `kod` = 'NH' WHERE `kod` = 'US034';
UPDATE `ulkesehir` SET `ust` = 'NH' WHERE `ust` = 'US034';
UPDATE `ulkesehir` SET `kod` = 'NM' WHERE `kod` = 'US037';
UPDATE `ulkesehir` SET `ust` = 'NM' WHERE `ust` = 'US037';
UPDATE `ulkesehir` SET `kod` = 'NY' WHERE `kod` = 'US038';
UPDATE `ulkesehir` SET `ust` = 'NY' WHERE `ust` = 'US038';
UPDATE `ulkesehir` SET `kod` = 'NC' WHERE `kod` = 'US039';
UPDATE `ulkesehir` SET `ust` = 'NC' WHERE `ust` = 'US039';
UPDATE `ulkesehir` SET `kod` = 'ND' WHERE `kod` = 'US040';
UPDATE `ulkesehir` SET `ust` = 'ND' WHERE `ust` = 'US040';
UPDATE `ulkesehir` SET `kod` = 'OH' WHERE `kod` = 'US041';
UPDATE `ulkesehir` SET `ust` = 'OH' WHERE `ust` = 'US041';
UPDATE `ulkesehir` SET `kod` = 'OK' WHERE `kod` = 'US042';
UPDATE `ulkesehir` SET `ust` = 'OK' WHERE `ust` = 'US042';
UPDATE `ulkesehir` SET `kod` = 'OR' WHERE `kod` = 'US044';
UPDATE `ulkesehir` SET `ust` = 'OR' WHERE `ust` = 'US044';
UPDATE `ulkesehir` SET `kod` = 'PA' WHERE `kod` = 'US045';
UPDATE `ulkesehir` SET `ust` = 'PA' WHERE `ust` = 'US045';
UPDATE `ulkesehir` SET `kod` = 'RI' WHERE `kod` = 'US047';
UPDATE `ulkesehir` SET `ust` = 'RI' WHERE `ust` = 'US047';
UPDATE `ulkesehir` SET `kod` = 'SC' WHERE `kod` = 'US048';
UPDATE `ulkesehir` SET `ust` = 'SC' WHERE `ust` = 'US048';
UPDATE `ulkesehir` SET `kod` = 'SD' WHERE `kod` = 'US049';
UPDATE `ulkesehir` SET `ust` = 'SD' WHERE `ust` = 'US049';
UPDATE `ulkesehir` SET `kod` = 'TN' WHERE `kod` = 'US051';
UPDATE `ulkesehir` SET `ust` = 'TN' WHERE `ust` = 'US051';
UPDATE `ulkesehir` SET `kod` = 'TX' WHERE `kod` = 'US052';
UPDATE `ulkesehir` SET `ust` = 'TX' WHERE `ust` = 'US052';
UPDATE `ulkesehir` SET `kod` = 'UT' WHERE `kod` = 'US054';
UPDATE `ulkesehir` SET `ust` = 'UT' WHERE `ust` = 'US054';
UPDATE `ulkesehir` SET `kod` = 'VT' WHERE `kod` = 'US055';
UPDATE `ulkesehir` SET `ust` = 'VT' WHERE `ust` = 'US055';
UPDATE `ulkesehir` SET `kod` = 'VA' WHERE `kod` = 'US056';
UPDATE `ulkesehir` SET `ust` = 'VA' WHERE `ust` = 'US056';
UPDATE `ulkesehir` SET `kod` = 'WA' WHERE `kod` = 'US057';
UPDATE `ulkesehir` SET `ust` = 'WA' WHERE `ust` = 'US057';
UPDATE `ulkesehir` SET `kod` = 'WV' WHERE `kod` = 'US058';
UPDATE `ulkesehir` SET `ust` = 'WV' WHERE `ust` = 'US058';
UPDATE `ulkesehir` SET `kod` = 'WI' WHERE `kod` = 'US059';
UPDATE `ulkesehir` SET `ust` = 'WI' WHERE `ust` = 'US059';
UPDATE `ulkesehir` SET `kod` = 'WY' WHERE `kod` = 'US060';
UPDATE `ulkesehir` SET `ust` = 'WY' WHERE `ust` = 'US060';