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