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,'')='';