select *,concat(left(userRegid,5),'***',right(userRegid,2)) as 'aaa' from usr_userid_fee as o
cancat 合并字符串
left(列名,截取字符串的个数) 从左边开始截取
right(列名,截取字符串的个数) 从右边边开始截取
最后一列数据查到的就是 12314***21
select *,concat(left(userRegid,5),'***',right(userRegid,2)) as 'aaa' from usr_userid_fee as o
cancat 合并字符串
left(列名,截取字符串的个数) 从左边开始截取
right(列名,截取字符串的个数) 从右边边开始截取
最后一列数据查到的就是 12314***21