
update security_person set nationality='中国' where nationality not in ('中国','CHN','阿鲁巴','美国','安哥拉','皮特凯恩群岛','香港','阿联酋','无国籍（难民）','南极洲');
update security_person  set driving_level='' where driving_level not in ('A1','C1','A2','B2','C3','C2','B1','A3','C4');
update security_person SET exp = 60 where exp >100;
update security_person set blood = replace(blood,'血型','');
update security_person set blood = replace(blood,'型','');
update security_person set blood = 'B' where blood='Ｂ';
update security_person set blood = 'AB' where blood='ＡＢ';
update security_person set blood = 'O' where blood='Ｏ';
update security_person set blood = 'O' where blood='0';
update security_person set blood = '' where blood not in ('A','B','AB','O','Rh阳','Rh阴');
update security_person set politics='3' where politics = '群众';
update security_person set politics='1' where politics = '党员';
update security_person set politics='2' where politics = '团员';
update security_person set marriage='1' where marriage='已婚';
update security_person set marriage='2' where marriage='未婚';
update security_person set marriage='3' where marriage='离异';
update security_person set personType='2' where personType='普通保安员';
update security_person set politics='' where politics not in ('1','2','3');
update security_person set marriage='' where marriage not in ('1','2','3');
update security_person set personType=null where personType not in ('1','2','3');