1.插入表数据
INSERT INTO tb_user (user_name,phone_num,address,sex)
select user_name,phone_num,address,9 from tb_userwhere 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;