+-----------------+-----------------+ 

• gen_rnd_ssn() 

Generates a random US Social Security number in AAA - BB - CCCC  format. The AAA  part is greater than 900 and the BB  part is less than 70, which are characteristics not used for legitimate Social Security numbers. 

Arguments: 

None. 

Return value: 

A random Social Security number as a string. 

Example: 

mysql> SELECT gen_rnd_ssn(); +---------------+ | gen_rnd_ssn() | +---------------+ | 951-26-0058 | +---------------+ 

• gen_rnd_us_phone() 

Generates a random US phone number in 1-555- AAA - BBBB  format. The 555 area code is not used for legitimate phone numbers. 

## Random Data Dictionary-Based Functions 

Arguments: 

None. 

Return value: 

A random US phone number as a string. 

Example: 

mysql> SELECT gen_rnd_us_phone(); +--------------------+ | gen_rnd_us_phone() | +--------------------+ | 1-555-682-5423 | +--------------------+ 

The functions in this section manipulate dictionaries of terms and perform generation and masking operations based on them. Some of these functions require the SUPER  privilege. 

When a dictionary is loaded, it becomes part of the dictionary registry and is assigned a name to be used by other dictionary functions. Dictionaries are loaded from plain text files containing one term per line. Empty lines are ignored. To be valid, a dictionary file must contain at least one nonempty line. 

• gen_blacklist( str , dictionary_name , replacement_dictionary_name ) 

