SQL Name, contact information-desensitization

SELECTOrder_project.project_type asattribute, Order_project.order_num,REPLACE(Customer.cust_name,substr (Customer.cust_name,2,1), "*") asPV, Customer.province asArea ,REPLACE(Customer.mobile,substr (Customer.mobile,4,4), "****") asMobile0 fromOrder_project, CUSTOMER, Order_logORDER  byorder_project.idDESCLIMITTen;

0. Name Desensitization, the second word of the name with a * to replace.

Implementation of the situation,

Sql:

SELECT REPLACE (Cust_name,substr (cust_name,2,1), "*") as name From ' table name ';

1. Contact information desensitization, the contact number in the middle of the four-digit replacement with *.

Implementation situation:

Sql:

Select REPLACE (Mobile,substr (mobile,2,1), "*") as name from ' table name ';

There are problems with this approach:

The method is to use the interception of the field, matching characters, if the name of the King big, then will match into the king * *, contact the same way.

SQL name, contact-desensitization