Mysql SQL statement to hide four digits in the middle of the phone number, mysqlsql

Mysql SQL statement to hide four digits in the middle of the phone number, mysqlsql

The first query table structure (sys_users ):

SELECT * from sys_users;

Method 1:Hide four digits in the middle of the phone number

Select REPLACE (mobile, SUBSTR (mobile, 4, 4), 'xxx') from sys_users

Method 2:Hide four digits in the middle of the phone number (recommended)

Select insert (mobile, 4, 4, 'xxxx') from sys_users;

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.