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