sql备忘

1.插入表数据

INSERT INTO tb_user (user_name,phone_num,address,sex)

select user_name,phone_num,address,9 from tb_user

where sex = 1;

2.用*替换查出来的手机号

select a.id,a.point_total,b.customer_name,b.avatar,a.rank,a.start_time,a.end_time,
(
case 
     when a.mobile REGEXP "^[1][35678][0-9]{9}$" then  INSERT(a.mobile, 4, 4, '****') 
     else b.customer_name
    end
)
as mobile
        from pointtotal a
        LEFT JOIN customer b
        on a.mobile=b.mobile
limit 10;