case when regexp '1(3[4-9]|4[7]|5[0-27-9]|8[2-478])[0-9]{9}$' then '移动'
when regexp '1(3[0-2]|4[5]|5[5-6]|7[6]|8[5-6])[0-9]{9}$' then '联通'
when regexp '1(3[3]|5[3]|7[37]|8[019])[0-9]{9}$' then '电信'
when regexp '1[0-9]{10}$' then '其他'
when not like '1%' then '异常'
end as telecoms