MySQL Enterprise Data Masking and De-Identification Function Reference For example, a masking view on the  customer  table from the previous section can be defined like this: Then the query to look up a customer becomes simpler but still returns masked data: 1583 6.5.4 MySQL Enterprise Data Masking and De-Identification Function Reference CREATE VIEW masked_customer AS SELECT id, first_name, last_name, mask_ssn(CONVERT(ssn USING binary)) AS masked_ssn FROM customer; mysql>  SELECT id, masked_ssn mysql>  FROM masked_customer mysql>  WHERE first_name = ’Joanna’ AND last_name = ’Bond’; +-----+-------------+ | id | masked_ssn | +-----+-------------+ | 786 | XXX-XX-0007 | +-----+-------------+ Table 6.38 MySQL Enterprise Data Masking and De-Identification Functions Name Description Introduced Deprecated gen_blacklist() Perform dictionary term replacement 8.0.23 gen_blocklist() Perform dictionary term replacement 8.0.23 gen_dictionary() Return random term from dictionary gen_dictionary_drop() Remove dictionary from registry gen_dictionary_load() Load dictionary into registry gen_range() Generate random number within range gen_rnd_email() Generate random email address gen_rnd_pan() Generate random payment card Primary Account Number gen_rnd_ssn() Generate random US Social Security number gen_rnd_us_phone() Generate random US phone number mask_inner() Mask interior part of string mask_outer() Mask left and right parts of string mask_pan() Mask payment card Primary Account Number part of string