<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="show-variables">
      </a>
      15.7.7.41 SHOW VARIABLES Statement
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045169033824">
  </a>
  <a class="indexterm" name="idm46045169032768">
  </a>
  <a class="indexterm" name="idm46045169031696">
  </a>
  <a class="indexterm" name="idm46045169030624">
  </a>
  <a class="indexterm" name="idm46045169029136">
  </a>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa76755248"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token keyword">SHOW</span> <span class="token punctuation">[</span><span class="token keyword">GLOBAL</span> <span class="token operator">|</span> <span class="token keyword">SESSION</span><span class="token punctuation">]</span> <span class="token keyword">VARIABLES</span>
    <span class="token punctuation">[</span><span class="token operator">LIKE</span> <span class="token string">'<em class="replaceable">pattern</em>'</span> <span class="token operator">|</span> <span class="token keyword">WHERE</span> <em class="replaceable">expr</em><span class="token punctuation">]</span></code></pre>
  </div>
  <a class="indexterm" name="idm46045169023776">
  </a>
  <p>
   <a class="link" href="show-variables.html" title="15.7.7.41 SHOW VARIABLES Statement">
    <code class="literal">
     SHOW VARIABLES
    </code>
   </a>
   shows the values
        of MySQL system variables (see
   <a class="xref" href="server-system-variables.html" title="7.1.8 Server System Variables">
    Section 7.1.8, “Server System Variables”
   </a>
   ). This statement does
        not require any privilege. It requires only the ability to
        connect to the server.
  </p>
  <p>
   System variable information is also available from these
        sources:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Performance Schema tables. See
      <a class="xref" href="performance-schema-system-variable-tables.html" title="29.12.14 Performance Schema System Variable Tables">
       Section 29.12.14, “Performance Schema System Variable Tables”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      The
      <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin variables
        </strong>
       </span>
      </a>
      command. See
      <a class="xref" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       Section 6.5.2, “mysqladmin — A MySQL Server Administration Program”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   For
   <a class="link" href="show-variables.html" title="15.7.7.41 SHOW VARIABLES Statement">
    <code class="literal">
     SHOW VARIABLES
    </code>
   </a>
   , a
   <a class="link" href="string-comparison-functions.html#operator_like">
    <code class="literal">
     LIKE
    </code>
   </a>
   clause, if present, indicates
        which variable names to match. A
   <code class="literal">
    WHERE
   </code>
   clause
        can be given to select rows using more general conditions, as
        discussed in
   <a class="xref" href="extended-show.html" title="28.8 Extensions to SHOW Statements">
    Section 28.8, “Extensions to SHOW Statements”
   </a>
   .
  </p>
  <p>
   <a class="link" href="show-variables.html" title="15.7.7.41 SHOW VARIABLES Statement">
    <code class="literal">
     SHOW VARIABLES
    </code>
   </a>
   accepts an
        optional
   <code class="literal">
    GLOBAL
   </code>
   or
   <code class="literal">
    SESSION
   </code>
   variable scope modifier:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      With a
      <code class="literal">
       GLOBAL
      </code>
      modifier, the statement
            displays global system variable values. These are the values
            used to initialize the corresponding session variables for
            new connections to MySQL. If a variable has no global value,
            no value is displayed.
     </p>
    </li>
    <li class="listitem">
     <p>
      With a
      <code class="literal">
       SESSION
      </code>
      modifier, the statement
            displays the system variable values that are in effect for
            the current connection. If a variable has no session value,
            the global value is displayed.
      <code class="literal">
       LOCAL
      </code>
      is a
            synonym for
      <code class="literal">
       SESSION
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      If no modifier is present, the default is
      <code class="literal">
       SESSION
      </code>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   The scope for each system variable is listed at
   <a class="xref" href="server-system-variables.html" title="7.1.8 Server System Variables">
    Section 7.1.8, “Server System Variables”
   </a>
   .
  </p>
  <p>
   <a class="link" href="show-variables.html" title="15.7.7.41 SHOW VARIABLES Statement">
    <code class="literal">
     SHOW VARIABLES
    </code>
   </a>
   is subject to a
        version-dependent display-width limit. For variables with very
        long values that are not completely displayed, use
   <a class="link" href="select.html" title="15.2.13 SELECT Statement">
    <code class="literal">
     SELECT
    </code>
   </a>
   as a workaround. For
        example:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa40872976"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token keyword">SELECT</span> <span class="token variable">@@GLOBAL.innodb_data_file_path</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   Most system variables can be set at server startup (read-only
        variables such as
   <a class="link" href="server-system-variables.html#sysvar_version_comment">
    <code class="literal">
     version_comment
    </code>
   </a>
   are
        exceptions). Many can be changed at runtime with the
   <a class="link" href="set-variable.html" title="15.7.6.1 SET Syntax for Variable Assignment">
    <code class="literal">
     SET
    </code>
   </a>
   statement. See
   <a class="xref" href="using-system-variables.html" title="7.1.9 Using System Variables">
    Section 7.1.9, “Using System Variables”
   </a>
   , and
   <a class="xref" href="set-variable.html" title="15.7.6.1 SET Syntax for Variable Assignment">
    Section 15.7.6.1, “SET Syntax for Variable Assignment”
   </a>
   .
  </p>
  <p>
   Partial output is shown here. The list of names and values may
        differ for your server.
   <a class="xref" href="server-system-variables.html" title="7.1.8 Server System Variables">
    Section 7.1.8, “Server System Variables”
   </a>
   , describes the meaning
        of each variable, and
   <a class="xref" href="server-configuration.html" title="7.1.1 Configuring the Server">
    Section 7.1.1, “Configuring the Server”
   </a>
   ,
        provides information about tuning them.
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa73449601"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">VARIABLES</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Variable_name                                         <span class="token punctuation">|</span> Value                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> activate_all_roles_on_login                           <span class="token punctuation">|</span> OFF                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> admin_address                                         <span class="token punctuation">|</span>                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> admin_port                                            <span class="token punctuation">|</span> 33062                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> admin_ssl_ca                                          <span class="token punctuation">|</span>                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> admin_ssl_capath                                      <span class="token punctuation">|</span>                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> admin_ssl_cert                                        <span class="token punctuation">|</span>                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> admin_ssl_cipher                                      <span class="token punctuation">|</span>                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> admin_ssl_crl                                         <span class="token punctuation">|</span>                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> admin_ssl_crlpath                                     <span class="token punctuation">|</span>                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> admin_ssl_key                                         <span class="token punctuation">|</span>                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> admin_tls_ciphersuites                                <span class="token punctuation">|</span>                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> admin_tls_version                                     <span class="token punctuation">|</span> TLSv1.2,TLSv1.3       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> authentication_policy                                 <span class="token punctuation">|</span> *,,                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> auto_generate_certs                                   <span class="token punctuation">|</span> ON                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> auto_increment_increment                              <span class="token punctuation">|</span> 1                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> auto_increment_offset                                 <span class="token punctuation">|</span> 1                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> autocommit                                            <span class="token punctuation">|</span> ON                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> automatic_sp_privileges                               <span class="token punctuation">|</span> ON                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> avoid_temporal_upgrade                                <span class="token punctuation">|</span> OFF                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> back_log                                              <span class="token punctuation">|</span> 151                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> basedir                                               <span class="token punctuation">|</span> /local/mysql<span class="token punctuation">-</span>8.4/     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> big_tables                                            <span class="token punctuation">|</span> OFF                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> bind_address                                          <span class="token punctuation">|</span> 127.0.0.1             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> binlog_cache_size                                     <span class="token punctuation">|</span> 32768                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> binlog_checksum                                       <span class="token punctuation">|</span> CRC32                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> binlog_direct_non_transactional_updates               <span class="token punctuation">|</span> OFF                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> binlog_encryption                                     <span class="token punctuation">|</span> OFF                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> binlog_error_action                                   <span class="token punctuation">|</span> ABORT_SERVER          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> binlog_expire_logs_auto_purge                         <span class="token punctuation">|</span> ON                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> binlog_expire_logs_seconds                            <span class="token punctuation">|</span> 2592000               <span class="token punctuation">|</span></span>
        
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>        
        
<span class="token output"><span class="token punctuation">|</span> max_error_count                                       <span class="token punctuation">|</span> 1024                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> max_execution_time                                    <span class="token punctuation">|</span> 0                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> max_heap_table_size                                   <span class="token punctuation">|</span> 16777216              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> max_insert_delayed_threads                            <span class="token punctuation">|</span> 20                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> max_join_size                                         <span class="token punctuation">|</span> 18446744073709551615  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> max_length_for_sort_data                              <span class="token punctuation">|</span> 4096                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> max_points_in_geometry                                <span class="token punctuation">|</span> 65536                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> max_prepared_stmt_count                               <span class="token punctuation">|</span> 16382                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> max_relay_log_size                                    <span class="token punctuation">|</span> 0                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> max_seeks_for_key                                     <span class="token punctuation">|</span> 18446744073709551615  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> max_sort_length                                       <span class="token punctuation">|</span> 1024                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> max_sp_recursion_depth                                <span class="token punctuation">|</span> 0                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> max_user_connections                                  <span class="token punctuation">|</span> 0                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> max_write_lock_count                                  <span class="token punctuation">|</span> 18446744073709551615  <span class="token punctuation">|</span></span>

<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>

<span class="token output"><span class="token punctuation">|</span> time_zone                                             <span class="token punctuation">|</span> SYSTEM                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> timestamp                                             <span class="token punctuation">|</span> 1682684938.710453     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> tls_certificates_enforced_validation                  <span class="token punctuation">|</span> OFF                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> tls_ciphersuites                                      <span class="token punctuation">|</span>                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> tls_version                                           <span class="token punctuation">|</span> TLSv1.2,TLSv1.3       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> tmp_table_size                                        <span class="token punctuation">|</span> 16777216              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> tmpdir                                                <span class="token punctuation">|</span> /tmp                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> transaction_alloc_block_size                          <span class="token punctuation">|</span> 8192                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> transaction_allow_batching                            <span class="token punctuation">|</span> OFF                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> transaction_isolation                                 <span class="token punctuation">|</span> REPEATABLE<span class="token punctuation">-</span>READ       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> transaction_prealloc_size                             <span class="token punctuation">|</span> 4096                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> transaction_read_only                                 <span class="token punctuation">|</span> OFF                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> unique_checks                                         <span class="token punctuation">|</span> ON                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> updatable_views_with_limit                            <span class="token punctuation">|</span> YES                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> use_secondary_engine                                  <span class="token punctuation">|</span> ON                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> version                                               <span class="token punctuation">|</span> 8.4.3                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> version_comment                                       <span class="token punctuation">|</span> Source distribution   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> version_compile_machine                               <span class="token punctuation">|</span> x86_64                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> version_compile_os                                    <span class="token punctuation">|</span> Linux                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> version_compile_zlib                                  <span class="token punctuation">|</span> 1.2.13                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> wait_timeout                                          <span class="token punctuation">|</span> 28800                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> warning_count                                         <span class="token punctuation">|</span> 0                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> windowing_use_high_precision                          <span class="token punctuation">|</span> ON                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> xa_detach_on_prepare                                  <span class="token punctuation">|</span> ON                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span></code></pre>
  </div>
  <p>
   With a
   <a class="link" href="string-comparison-functions.html#operator_like">
    <code class="literal">
     LIKE
    </code>
   </a>
   clause, the statement
        displays only rows for those variables with names that match the
        pattern. To obtain the row for a specific variable, use a
   <a class="link" href="string-comparison-functions.html#operator_like">
    <code class="literal">
     LIKE
    </code>
   </a>
   clause as shown:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa44685169"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token keyword">SHOW</span> <span class="token keyword">VARIABLES</span> <span class="token operator">LIKE</span> <span class="token string">'max_join_size'</span><span class="token punctuation">;</span>
<span class="token keyword">SHOW</span> <span class="token keyword">SESSION</span> <span class="token keyword">VARIABLES</span> <span class="token operator">LIKE</span> <span class="token string">'max_join_size'</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   To get a list of variables whose name match a pattern, use the
   <code class="literal">
    %
   </code>
   wildcard character in a
   <a class="link" href="string-comparison-functions.html#operator_like">
    <code class="literal">
     LIKE
    </code>
   </a>
   clause:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa26217170"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token keyword">SHOW</span> <span class="token keyword">VARIABLES</span> <span class="token operator">LIKE</span> <span class="token string">'%size%'</span><span class="token punctuation">;</span>
<span class="token keyword">SHOW</span> <span class="token keyword">GLOBAL</span> <span class="token keyword">VARIABLES</span> <span class="token operator">LIKE</span> <span class="token string">'%size%'</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   Wildcard characters can be used in any position within the
        pattern to be matched. Strictly speaking, because
   <code class="literal">
    _
   </code>
   is a wildcard that matches any single
        character, you should escape it as
   <code class="literal">
    \_
   </code>
   to
        match it literally. In practice, this is rarely necessary.
  </p>
 </div>
 <br/>
</div>
