MySQL SQL statement method to hide the middle four digits of the mobile phone number

First query table structure (sys_users):

SELECT * from sys_users;

The first method: Hide the middle four digits of the mobile phone number

select REPLACE(mobile, SUBSTR(mobile,4,4), 'XXXX') from sys_users

The second method: Hide the middle four digits of the mobile phone number (recommended)

select insert(mobile, 4, 4, 'XXXX') from sys_users;

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.