CONCAT_WS函数
CONCAT_Ws( '****', SUBSTRINg(phone,1,3),SUBSTRINg(phone, 8, 4))
demo:
select consignee, CONCAT_Ws( '****', SUBSTRINg(phone,1,3),SUBSTRINg(phone, 8, 4)) from t_order where out_order_code = '1627912858-001';
CONCAT_WS函数
CONCAT_Ws( '****', SUBSTRINg(phone,1,3),SUBSTRINg(phone, 8, 4))
demo:
select consignee, CONCAT_Ws( '****', SUBSTRINg(phone,1,3),SUBSTRINg(phone, 8, 4)) from t_order where out_order_code = '1627912858-001';
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
