查询:正则表达式匹配手机号码
select auth_user.sid from auth_user where regexp_like(auth_user.user_pin ,'^1[35678][0-9]{9}');
更新:正则表达式匹配手机号码
update auth_user set auth_user.value2 = '1' where auth_user.sid not in (select auth_user.sid from auth_user where regexp_like(auth_user.user_pin ,'^1[35678][0-9]{9}'))