DIGITAL_MASKING

description

Syntax

digital_masking(digital_number)

This is an alias function. The original function of it is concat(left(id,3),'****',right(id,4)).

It desensitizes the input digital_number and returns the result after desensitization. digital_number is ofBIGINT data type.

Example

1. Desensitize the cell phone number

   mysql> select digital_masking(13812345678);
   +------------------------------+
   | digital_masking(13812345678) |
   +------------------------------+
   | 138****5678                  |
   +------------------------------+

Keywords

DIGITAL_MASKING