DIGITAL_MASKING

description

Syntax

  1. digital_masking(digital_number)

Alias function, the original function is concat(left(id,3),'****',right(id,4)).

Desensitizes the input digital_number and returns the result after masking desensitization. digital_number is BIGINT data type.

example

  1. Desensitize the cell phone number

    1. mysql> select digital_masking(13812345678);
    2. +------------------------------+
    3. | digital_masking(13812345678) |
    4. +------------------------------+
    5. | 138****5678                  |
    6. +------------------------------+

keywords

DIGITAL_MASKING