 

update `problemperson` set personType = '1' where problemtype='身份证号不存在' or problemtype ='姓名信息有误';

update `problemperson` set personType = '2' where problemtype  like '%在逃%';


update `problemperson` set personType = '3' where ifnull(personType,'')='';
 