<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="data-masking-plugin-function-reference">
      </a>
      8.5.3.3 MySQL Enterprise Data Masking and De-Identification Plugin Function Reference
     </h4>
    </div>
   </div>
  </div>
  <div class="table">
   <a name="idm46045232326048">
   </a>
   <p class="title">
    <b>
     Table 8.47 MySQL Enterprise Data Masking and De-Identification Plugin Functions
    </b>
   </p>
   <div class="table-contents">
    <table frame="box" rules="all" summary="A reference that lists MySQL Enterprise Data Masking and De-Identification plugin functions.">
     <colgroup>
      <col style="width: 25%"/>
      <col style="width: 62%"/>
      <col style="width: 12%"/>
     </colgroup>
     <thead>
      <tr>
       <th>
        Name
       </th>
       <th>
        Description
       </th>
       <th>
        Deprecated
       </th>
      </tr>
     </thead>
     <tbody>
      <tr>
       <th scope="row">
        <a class="link" href="data-masking-plugin-functions.html#function_gen-blacklist-plugin">
         <code class="literal">
          gen_blacklist()
         </code>
        </a>
       </th>
       <td>
        Perform dictionary term replacement
       </td>
       <td>
        Yes
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="data-masking-plugin-functions.html#function_gen-blocklist-plugin">
         <code class="literal">
          gen_blocklist()
         </code>
        </a>
       </th>
       <td>
        Perform dictionary term replacement
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="data-masking-plugin-functions.html#function_gen-dictionary-drop-plugin">
         <code class="literal">
          gen_dictionary_drop()
         </code>
        </a>
       </th>
       <td>
        Remove dictionary from registry
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="data-masking-plugin-functions.html#function_gen-dictionary-load-plugin">
         <code class="literal">
          gen_dictionary_load()
         </code>
        </a>
       </th>
       <td>
        Load dictionary into registry
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="data-masking-plugin-functions.html#function_gen-dictionary-plugin">
         <code class="literal">
          gen_dictionary()
         </code>
        </a>
       </th>
       <td>
        Return random term from dictionary
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="data-masking-plugin-functions.html#function_gen-range-plugin">
         <code class="literal">
          gen_range()
         </code>
        </a>
       </th>
       <td>
        Generate random number within range
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="data-masking-plugin-functions.html#function_gen-rnd-email-plugin">
         <code class="literal">
          gen_rnd_email()
         </code>
        </a>
       </th>
       <td>
        Generate random email address
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="data-masking-plugin-functions.html#function_gen-rnd-pan-plugin">
         <code class="literal">
          gen_rnd_pan()
         </code>
        </a>
       </th>
       <td>
        Generate random payment card Primary Account Number
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="data-masking-plugin-functions.html#function_gen-rnd-ssn-plugin">
         <code class="literal">
          gen_rnd_ssn()
         </code>
        </a>
       </th>
       <td>
        Generate random US Social Security Number
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="data-masking-plugin-functions.html#function_gen-rnd-us-phone-plugin">
         <code class="literal">
          gen_rnd_us_phone()
         </code>
        </a>
       </th>
       <td>
        Generate random US phone number
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="data-masking-plugin-functions.html#function_mask-inner-plugin">
         <code class="literal">
          mask_inner()
         </code>
        </a>
       </th>
       <td>
        Mask interior part of string
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="data-masking-plugin-functions.html#function_mask-outer-plugin">
         <code class="literal">
          mask_outer()
         </code>
        </a>
       </th>
       <td>
        Mask left and right parts of string
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="data-masking-plugin-functions.html#function_mask-pan-plugin">
         <code class="literal">
          mask_pan()
         </code>
        </a>
       </th>
       <td>
        Mask payment card Primary Account Number part of string
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="data-masking-plugin-functions.html#function_mask-pan-relaxed-plugin">
         <code class="literal">
          mask_pan_relaxed()
         </code>
        </a>
       </th>
       <td>
        Mask payment card Primary Account Number part of string
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="data-masking-plugin-functions.html#function_mask-ssn-plugin">
         <code class="literal">
          mask_ssn()
         </code>
        </a>
       </th>
       <td>
        Mask US Social Security Number
       </td>
       <td>
       </td>
      </tr>
     </tbody>
    </table>
   </div>
   <div class="table-contents">
    <table cellpadding="0" cellspacing="0" style="position: fixed; top: 0px; display: none; left: 401px; width: 739px;">
     <thead>
      <tr>
       <th style="width: 186.203px;">
        Name
       </th>
       <th style="width: 461.797px;">
        Description
       </th>
       <th style="width: 90px;">
        Deprecated
       </th>
      </tr>
     </thead>
    </table>
   </div>
  </div>
  <br class="table-break"/>
 </div>
 <br/>
</div>
