DIGITAL_MASKING
description
Syntax
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.
example
Desensitize the cell phone number
mysql> select digital_masking(13812345678);
+------------------------------+
| digital_masking(13812345678) |
+------------------------------+
| 138****5678 |
+------------------------------+
keyword
DIGITAL_MASKING