use repoa;
UPDATE area SET szAreaDescription  = 'Kibaha T.C' WHERE szAreaDescription = "Kibaha Urban";
UPDATE area SET szAreaDescription  = 'Mbeya C.C' WHERE szAreaDescription = "Mbeya M.C";
UPDATE area SET szAreaDescription  = 'Mwanza C.C' WHERE szAreaDescription = "Mwanza M.C";
UPDATE area SET szAreaDescription  = 'Korogwe T.C' WHERE szAreaDescription = "Korogwe Urban";
UPDATE area SET szAreaDescription  = 'Sumbawanga M.C' WHERE szAreaDescription = "Sumbawanga T.C";
UPDATE area SET szAreaDescription  = 'Babati T.C' WHERE szAreaDescription = "Babati Urban";
UPDATE area SET szAreaDescription  = 'Mbeya D.C' WHERE szAreaDescription = "Mbeya Rural";




