<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="built-in-function-reference">
      </a>
      14.1 Built-In Function and Operator Reference
     </h2>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045210262640">
  </a>
  <a class="indexterm" name="idm46045210261152">
  </a>
  <a class="indexterm" name="idm46045210259664">
  </a>
  <a class="indexterm" name="idm46045210258176">
  </a>
  <p>
   The following table lists each built-in (native) function and
      operator and provides a short description of each one. For a table
      listing functions that are loadable at runtime, see
   <a class="xref" href="loadable-function-reference.html" title="14.2 Loadable Function Reference">
    Section 14.2, “Loadable Function Reference”
   </a>
   .
  </p>
  <div class="table">
   <a name="idm46045210255376">
   </a>
   <p class="title">
    <b>
     Table 14.1 Built-In Functions and Operators
    </b>
   </p>
   <div class="table-contents">
    <table frame="box" rules="all" summary="A reference that lists all built-in functions and operators.">
     <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="bit-functions.html#operator_bitwise-and">
         <code class="literal">
          &amp;
         </code>
        </a>
       </th>
       <td>
        Bitwise AND
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_greater-than">
         <code class="literal">
          &gt;
         </code>
        </a>
       </th>
       <td>
        Greater than operator
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="bit-functions.html#operator_right-shift">
         <code class="literal">
          &gt;&gt;
         </code>
        </a>
       </th>
       <td>
        Right shift
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_greater-than-or-equal">
         <code class="literal">
          &gt;=
         </code>
        </a>
       </th>
       <td>
        Greater than or equal operator
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_less-than">
         <code class="literal">
          &lt;
         </code>
        </a>
       </th>
       <td>
        Less than operator
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_not-equal">
         <code class="literal">
          &lt;&gt;
         </code>
         ,
         <code class="literal">
          !=
         </code>
        </a>
       </th>
       <td>
        Not equal operator
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="bit-functions.html#operator_left-shift">
         <code class="literal">
          &lt;&lt;
         </code>
        </a>
       </th>
       <td>
        Left shift
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_less-than-or-equal">
         <code class="literal">
          &lt;=
         </code>
        </a>
       </th>
       <td>
        Less than or equal operator
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_equal-to">
         <code class="literal">
          &lt;=&gt;
         </code>
        </a>
       </th>
       <td>
        NULL-safe equal to operator
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="arithmetic-functions.html#operator_mod">
         <code class="literal">
          %
         </code>
         ,
         <code class="literal">
          MOD
         </code>
        </a>
       </th>
       <td>
        Modulo operator
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="arithmetic-functions.html#operator_times">
         <code class="literal">
          *
         </code>
        </a>
       </th>
       <td>
        Multiplication operator
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="arithmetic-functions.html#operator_plus">
         <code class="literal">
          +
         </code>
        </a>
       </th>
       <td>
        Addition operator
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="arithmetic-functions.html#operator_minus">
         <code class="literal">
          -
         </code>
        </a>
       </th>
       <td>
        Minus operator
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="arithmetic-functions.html#operator_unary-minus">
         <code class="literal">
          -
         </code>
        </a>
       </th>
       <td>
        Change the sign of the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-search-functions.html#operator_json-column-path">
         <code class="literal">
          -&gt;
         </code>
        </a>
       </th>
       <td>
        Return value from JSON column after evaluating path; equivalent to
      JSON_EXTRACT().
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-search-functions.html#operator_json-inline-path">
         <code class="literal">
          -&gt;&gt;
         </code>
        </a>
       </th>
       <td>
        Return value from JSON column after evaluating path and unquoting
      the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()).
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="arithmetic-functions.html#operator_divide">
         <code class="literal">
          /
         </code>
        </a>
       </th>
       <td>
        Division operator
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="assignment-operators.html#operator_assign-value">
         <code class="literal">
          :=
         </code>
        </a>
       </th>
       <td>
        Assign a value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="assignment-operators.html#operator_assign-equal">
         <code class="literal">
          =
         </code>
        </a>
       </th>
       <td>
        Assign a value (as part of a
        <a class="link" href="set-variable.html" title="15.7.6.1 SET Syntax for Variable Assignment">
         <code class="literal">
          SET
         </code>
        </a>
        statement, or as part of the
        <code class="literal">
         SET
        </code>
        clause in an
        <a class="link" href="update.html" title="15.2.17 UPDATE Statement">
         <code class="literal">
          UPDATE
         </code>
        </a>
        statement)
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_equal">
         <code class="literal">
          =
         </code>
        </a>
       </th>
       <td>
        Equal operator
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="bit-functions.html#operator_bitwise-xor">
         <code class="literal">
          ^
         </code>
        </a>
       </th>
       <td>
        Bitwise XOR
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_abs">
         <code class="literal">
          ABS()
         </code>
        </a>
       </th>
       <td>
        Return the absolute value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_acos">
         <code class="literal">
          ACOS()
         </code>
        </a>
       </th>
       <td>
        Return the arc cosine
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_adddate">
         <code class="literal">
          ADDDATE()
         </code>
        </a>
       </th>
       <td>
        Add time values (intervals) to a date value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_addtime">
         <code class="literal">
          ADDTIME()
         </code>
        </a>
       </th>
       <td>
        Add time
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="encryption-functions.html#function_aes-decrypt">
         <code class="literal">
          AES_DECRYPT()
         </code>
        </a>
       </th>
       <td>
        Decrypt using AES
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="encryption-functions.html#function_aes-encrypt">
         <code class="literal">
          AES_ENCRYPT()
         </code>
        </a>
       </th>
       <td>
        Encrypt using AES
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="logical-operators.html#operator_and">
         <code class="literal">
          AND
         </code>
         ,
         <code class="literal">
          &amp;&amp;
         </code>
        </a>
       </th>
       <td>
        Logical AND
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="miscellaneous-functions.html#function_any-value">
         <code class="literal">
          ANY_VALUE()
         </code>
        </a>
       </th>
       <td>
        Suppress ONLY_FULL_GROUP_BY value rejection
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_ascii">
         <code class="literal">
          ASCII()
         </code>
        </a>
       </th>
       <td>
        Return numeric value of left-most character
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_asin">
         <code class="literal">
          ASIN()
         </code>
        </a>
       </th>
       <td>
        Return the arc sine
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="replication-functions-async-failover.html#function_asynchronous-connection-failover-add-managed">
         <code class="literal">
          asynchronous_connection_failover_add_managed()
         </code>
        </a>
       </th>
       <td>
        Add group member source server configuration information to a
      replication channel source list
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="replication-functions-async-failover.html#function_asynchronous-connection-failover-add-source">
         <code class="literal">
          asynchronous_connection_failover_add_source()
         </code>
        </a>
       </th>
       <td>
        Add source server configuration information server to a
      replication channel source list
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="replication-functions-async-failover.html#function_asynchronous-connection-failover-delete-managed">
         <code class="literal">
          asynchronous_connection_failover_delete_managed()
         </code>
        </a>
       </th>
       <td>
        Remove a managed group from a replication channel source list
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="replication-functions-async-failover.html#function_asynchronous-connection-failover-delete-source">
         <code class="literal">
          asynchronous_connection_failover_delete_source()
         </code>
        </a>
       </th>
       <td>
        Remove a source server from a replication channel source list
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="replication-functions-async-failover.html#function_asynchronous-connection-failover-reset">
         <code class="literal">
          asynchronous_connection_failover_reset()
         </code>
        </a>
       </th>
       <td>
        Remove all settings relating to group replication asynchronous
      failover
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_atan">
         <code class="literal">
          ATAN()
         </code>
        </a>
       </th>
       <td>
        Return the arc tangent
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_atan2">
         <code class="literal">
          ATAN2()
         </code>
         ,
         <code class="literal">
          ATAN()
         </code>
        </a>
       </th>
       <td>
        Return the arc tangent of the two arguments
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_avg">
         <code class="literal">
          AVG()
         </code>
        </a>
       </th>
       <td>
        Return the average value of the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_benchmark">
         <code class="literal">
          BENCHMARK()
         </code>
        </a>
       </th>
       <td>
        Repeatedly execute an expression
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_between">
         <code class="literal">
          BETWEEN ... AND ...
         </code>
        </a>
       </th>
       <td>
        Whether a value is within a range of values
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_bin">
         <code class="literal">
          BIN()
         </code>
        </a>
       </th>
       <td>
        Return a string containing binary representation of a number
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="miscellaneous-functions.html#function_bin-to-uuid">
         <code class="literal">
          BIN_TO_UUID()
         </code>
        </a>
       </th>
       <td>
        Convert binary UUID to string
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="cast-functions.html#operator_binary">
         <code class="literal">
          BINARY
         </code>
        </a>
       </th>
       <td>
        Cast a string to a binary string
       </td>
       <td>
        Yes
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_bit-and">
         <code class="literal">
          BIT_AND()
         </code>
        </a>
       </th>
       <td>
        Return bitwise AND
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="bit-functions.html#function_bit-count">
         <code class="literal">
          BIT_COUNT()
         </code>
        </a>
       </th>
       <td>
        Return the number of bits that are set
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_bit-length">
         <code class="literal">
          BIT_LENGTH()
         </code>
        </a>
       </th>
       <td>
        Return length of argument in bits
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_bit-or">
         <code class="literal">
          BIT_OR()
         </code>
        </a>
       </th>
       <td>
        Return bitwise OR
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_bit-xor">
         <code class="literal">
          BIT_XOR()
         </code>
        </a>
       </th>
       <td>
        Return bitwise XOR
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_can-access-column">
         <code class="literal">
          CAN_ACCESS_COLUMN()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_can-access-database">
         <code class="literal">
          CAN_ACCESS_DATABASE()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_can-access-table">
         <code class="literal">
          CAN_ACCESS_TABLE()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_can-access-user">
         <code class="literal">
          CAN_ACCESS_USER()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_can-access-view">
         <code class="literal">
          CAN_ACCESS_VIEW()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="flow-control-functions.html#operator_case">
         <code class="literal">
          CASE
         </code>
        </a>
       </th>
       <td>
        Case operator
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="cast-functions.html#function_cast">
         <code class="literal">
          CAST()
         </code>
        </a>
       </th>
       <td>
        Cast a value as a certain type
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_ceil">
         <code class="literal">
          CEIL()
         </code>
        </a>
       </th>
       <td>
        Return the smallest integer value not less than the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_ceiling">
         <code class="literal">
          CEILING()
         </code>
        </a>
       </th>
       <td>
        Return the smallest integer value not less than the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_char">
         <code class="literal">
          CHAR()
         </code>
        </a>
       </th>
       <td>
        Return the character for each integer passed
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_char-length">
         <code class="literal">
          CHAR_LENGTH()
         </code>
        </a>
       </th>
       <td>
        Return number of characters in argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_character-length">
         <code class="literal">
          CHARACTER_LENGTH()
         </code>
        </a>
       </th>
       <td>
        Synonym for CHAR_LENGTH()
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_charset">
         <code class="literal">
          CHARSET()
         </code>
        </a>
       </th>
       <td>
        Return the character set of the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#function_coalesce">
         <code class="literal">
          COALESCE()
         </code>
        </a>
       </th>
       <td>
        Return the first non-NULL argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_coercibility">
         <code class="literal">
          COERCIBILITY()
         </code>
        </a>
       </th>
       <td>
        Return the collation coercibility value of the string argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_collation">
         <code class="literal">
          COLLATION()
         </code>
        </a>
       </th>
       <td>
        Return the collation of the string argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="encryption-functions.html#function_compress">
         <code class="literal">
          COMPRESS()
         </code>
        </a>
       </th>
       <td>
        Return result as a binary string
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_concat">
         <code class="literal">
          CONCAT()
         </code>
        </a>
       </th>
       <td>
        Return concatenated string
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_concat-ws">
         <code class="literal">
          CONCAT_WS()
         </code>
        </a>
       </th>
       <td>
        Return concatenate with separator
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_connection-id">
         <code class="literal">
          CONNECTION_ID()
         </code>
        </a>
       </th>
       <td>
        Return the connection ID (thread ID) for the connection
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_conv">
         <code class="literal">
          CONV()
         </code>
        </a>
       </th>
       <td>
        Convert numbers between different number bases
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="cast-functions.html#function_convert">
         <code class="literal">
          CONVERT()
         </code>
        </a>
       </th>
       <td>
        Cast a value as a certain type
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_convert-tz">
         <code class="literal">
          CONVERT_TZ()
         </code>
        </a>
       </th>
       <td>
        Convert from one time zone to another
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_cos">
         <code class="literal">
          COS()
         </code>
        </a>
       </th>
       <td>
        Return the cosine
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_cot">
         <code class="literal">
          COT()
         </code>
        </a>
       </th>
       <td>
        Return the cotangent
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_count">
         <code class="literal">
          COUNT()
         </code>
        </a>
       </th>
       <td>
        Return a count of the number of rows returned
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_count-distinct">
         <code class="literal">
          COUNT(DISTINCT)
         </code>
        </a>
       </th>
       <td>
        Return the count of a number of different values
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_crc32">
         <code class="literal">
          CRC32()
         </code>
        </a>
       </th>
       <td>
        Compute a cyclic redundancy check value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="window-function-descriptions.html#function_cume-dist">
         <code class="literal">
          CUME_DIST()
         </code>
        </a>
       </th>
       <td>
        Cumulative distribution value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_curdate">
         <code class="literal">
          CURDATE()
         </code>
        </a>
       </th>
       <td>
        Return the current date
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_current-date">
         <code class="literal">
          CURRENT_DATE()
         </code>
         ,
         <code class="literal">
          CURRENT_DATE
         </code>
        </a>
       </th>
       <td>
        Synonyms for CURDATE()
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_current-role">
         <code class="literal">
          CURRENT_ROLE()
         </code>
        </a>
       </th>
       <td>
        Return the current active roles
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_current-time">
         <code class="literal">
          CURRENT_TIME()
         </code>
         ,
         <code class="literal">
          CURRENT_TIME
         </code>
        </a>
       </th>
       <td>
        Synonyms for CURTIME()
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_current-timestamp">
         <code class="literal">
          CURRENT_TIMESTAMP()
         </code>
         ,
         <code class="literal">
          CURRENT_TIMESTAMP
         </code>
        </a>
       </th>
       <td>
        Synonyms for NOW()
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_current-user">
         <code class="literal">
          CURRENT_USER()
         </code>
         ,
         <code class="literal">
          CURRENT_USER
         </code>
        </a>
       </th>
       <td>
        The authenticated user name and host name
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_curtime">
         <code class="literal">
          CURTIME()
         </code>
        </a>
       </th>
       <td>
        Return the current time
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_database">
         <code class="literal">
          DATABASE()
         </code>
        </a>
       </th>
       <td>
        Return the default (current) database name
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_date">
         <code class="literal">
          DATE()
         </code>
        </a>
       </th>
       <td>
        Extract the date part of a date or datetime expression
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_date-add">
         <code class="literal">
          DATE_ADD()
         </code>
        </a>
       </th>
       <td>
        Add time values (intervals) to a date value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_date-format">
         <code class="literal">
          DATE_FORMAT()
         </code>
        </a>
       </th>
       <td>
        Format date as specified
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_date-sub">
         <code class="literal">
          DATE_SUB()
         </code>
        </a>
       </th>
       <td>
        Subtract a time value (interval) from a date
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_datediff">
         <code class="literal">
          DATEDIFF()
         </code>
        </a>
       </th>
       <td>
        Subtract two dates
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_day">
         <code class="literal">
          DAY()
         </code>
        </a>
       </th>
       <td>
        Synonym for DAYOFMONTH()
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_dayname">
         <code class="literal">
          DAYNAME()
         </code>
        </a>
       </th>
       <td>
        Return the name of the weekday
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_dayofmonth">
         <code class="literal">
          DAYOFMONTH()
         </code>
        </a>
       </th>
       <td>
        Return the day of the month (0-31)
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_dayofweek">
         <code class="literal">
          DAYOFWEEK()
         </code>
        </a>
       </th>
       <td>
        Return the weekday index of the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_dayofyear">
         <code class="literal">
          DAYOFYEAR()
         </code>
        </a>
       </th>
       <td>
        Return the day of the year (1-366)
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="miscellaneous-functions.html#function_default">
         <code class="literal">
          DEFAULT()
         </code>
        </a>
       </th>
       <td>
        Return the default value for a table column
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_degrees">
         <code class="literal">
          DEGREES()
         </code>
        </a>
       </th>
       <td>
        Convert radians to degrees
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="window-function-descriptions.html#function_dense-rank">
         <code class="literal">
          DENSE_RANK()
         </code>
        </a>
       </th>
       <td>
        Rank of current row within its partition, without gaps
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="arithmetic-functions.html#operator_div">
         <code class="literal">
          DIV
         </code>
        </a>
       </th>
       <td>
        Integer division
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_elt">
         <code class="literal">
          ELT()
         </code>
        </a>
       </th>
       <td>
        Return string at index number
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_exists">
         <code class="literal">
          EXISTS()
         </code>
        </a>
       </th>
       <td>
        Whether the result of a query contains any rows
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_exp">
         <code class="literal">
          EXP()
         </code>
        </a>
       </th>
       <td>
        Raise to the power of
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_export-set">
         <code class="literal">
          EXPORT_SET()
         </code>
        </a>
       </th>
       <td>
        Return a string such that for every bit set in the value bits, you
      get an on string and for every unset bit, you get an off string
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_extract">
         <code class="literal">
          EXTRACT()
         </code>
        </a>
       </th>
       <td>
        Extract part of a date
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="xml-functions.html#function_extractvalue">
         <code class="literal">
          ExtractValue()
         </code>
        </a>
       </th>
       <td>
        Extract a value from an XML string using XPath notation
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_field">
         <code class="literal">
          FIELD()
         </code>
        </a>
       </th>
       <td>
        Index (position) of first argument in subsequent arguments
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_find-in-set">
         <code class="literal">
          FIND_IN_SET()
         </code>
        </a>
       </th>
       <td>
        Index (position) of first argument within second argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="window-function-descriptions.html#function_first-value">
         <code class="literal">
          FIRST_VALUE()
         </code>
        </a>
       </th>
       <td>
        Value of argument from first row of window frame
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_floor">
         <code class="literal">
          FLOOR()
         </code>
        </a>
       </th>
       <td>
        Return the largest integer value not greater than the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_format">
         <code class="literal">
          FORMAT()
         </code>
        </a>
       </th>
       <td>
        Return a number formatted to specified number of decimal places
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="performance-schema-functions.html#function_format-bytes">
         <code class="literal">
          FORMAT_BYTES()
         </code>
        </a>
       </th>
       <td>
        Convert byte count to value with units
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="performance-schema-functions.html#function_format-pico-time">
         <code class="literal">
          FORMAT_PICO_TIME()
         </code>
        </a>
       </th>
       <td>
        Convert time in picoseconds to value with units
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_found-rows">
         <code class="literal">
          FOUND_ROWS()
         </code>
        </a>
       </th>
       <td>
        For a SELECT with a LIMIT clause, the number of rows that would be
      returned were there no LIMIT clause
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_from-days">
         <code class="literal">
          FROM_DAYS()
         </code>
        </a>
       </th>
       <td>
        Convert a day number to a date
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_from-unixtime">
         <code class="literal">
          FROM_UNIXTIME()
         </code>
        </a>
       </th>
       <td>
        Format Unix timestamp as a date
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-mysql-specific-functions.html#function_geomcollection">
         <code class="literal">
          GeomCollection()
         </code>
        </a>
       </th>
       <td>
        Construct geometry collection from geometries
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-mysql-specific-functions.html#function_geometrycollection">
         <code class="literal">
          GeometryCollection()
         </code>
        </a>
       </th>
       <td>
        Construct geometry collection from geometries
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_get-dd-column-privileges">
         <code class="literal">
          GET_DD_COLUMN_PRIVILEGES()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_get-dd-create-options">
         <code class="literal">
          GET_DD_CREATE_OPTIONS()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_get-dd-index-sub-part-length">
         <code class="literal">
          GET_DD_INDEX_SUB_PART_LENGTH()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_get-format">
         <code class="literal">
          GET_FORMAT()
         </code>
        </a>
       </th>
       <td>
        Return a date format string
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="locking-functions.html#function_get-lock">
         <code class="literal">
          GET_LOCK()
         </code>
        </a>
       </th>
       <td>
        Get a named lock
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#function_greatest">
         <code class="literal">
          GREATEST()
         </code>
        </a>
       </th>
       <td>
        Return the largest argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_group-concat">
         <code class="literal">
          GROUP_CONCAT()
         </code>
        </a>
       </th>
       <td>
        Return a concatenated string
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="group-replication-functions-for-member-actions.html#function_group-replication-disable-member-action">
         <code class="literal">
          group_replication_disable_member_action()
         </code>
        </a>
       </th>
       <td>
        Disable member action for event specified
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="group-replication-functions-for-member-actions.html#function_group-replication-enable-member-action">
         <code class="literal">
          group_replication_enable_member_action()
         </code>
        </a>
       </th>
       <td>
        Enable member action for event specified
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="group-replication-functions-for-communication-protocol.html#function_group-replication-get-communication-protocol">
         <code class="literal">
          group_replication_get_communication_protocol()
         </code>
        </a>
       </th>
       <td>
        Get version of group replication communication protocol currently
      in use
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="group-replication-functions-for-maximum-consensus.html#function_group-replication-get-write-concurrency">
         <code class="literal">
          group_replication_get_write_concurrency()
         </code>
        </a>
       </th>
       <td>
        Get maximum number of consensus instances currently set for group
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="group-replication-functions-for-member-actions.html#function_group-replication-reset-member-actions">
         <code class="literal">
          group_replication_reset_member_actions()
         </code>
        </a>
       </th>
       <td>
        Reset all member actions to defaults and configuration version
      number to 1
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="group-replication-functions-for-new-primary.html#function_group-replication-set-as-primary">
         <code class="literal">
          group_replication_set_as_primary()
         </code>
        </a>
       </th>
       <td>
        Make a specific group member the primary
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="group-replication-functions-for-communication-protocol.html#function_group-replication-set-communication-protocol">
         <code class="literal">
          group_replication_set_communication_protocol()
         </code>
        </a>
       </th>
       <td>
        Set version for group replication communication protocol to use
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="group-replication-functions-for-maximum-consensus.html#function_group-replication-set-write-concurrency">
         <code class="literal">
          group_replication_set_write_concurrency()
         </code>
        </a>
       </th>
       <td>
        Set maximum number of consensus instances that can be executed in
      parallel
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="group-replication-functions-for-mode.html#function_group-replication-switch-to-multi-primary-mode">
         <code class="literal">
          group_replication_switch_to_multi_primary_mode()
         </code>
        </a>
       </th>
       <td>
        Changes the mode of a group running in single-primary mode to
      multi-primary mode
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="group-replication-functions-for-mode.html#function_group-replication-switch-to-single-primary-mode">
         <code class="literal">
          group_replication_switch_to_single_primary_mode()
         </code>
        </a>
       </th>
       <td>
        Changes the mode of a group running in multi-primary mode to
      single-primary mode
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="miscellaneous-functions.html#function_grouping">
         <code class="literal">
          GROUPING()
         </code>
        </a>
       </th>
       <td>
        Distinguish super-aggregate ROLLUP rows from regular rows
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_hex">
         <code class="literal">
          HEX()
         </code>
        </a>
       </th>
       <td>
        Hexadecimal representation of decimal or string value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_hour">
         <code class="literal">
          HOUR()
         </code>
        </a>
       </th>
       <td>
        Extract the hour
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_icu-version">
         <code class="literal">
          ICU_VERSION()
         </code>
        </a>
       </th>
       <td>
        ICU library version
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="flow-control-functions.html#function_if">
         <code class="literal">
          IF()
         </code>
        </a>
       </th>
       <td>
        If/else construct
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="flow-control-functions.html#function_ifnull">
         <code class="literal">
          IFNULL()
         </code>
        </a>
       </th>
       <td>
        Null if/else construct
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_in">
         <code class="literal">
          IN()
         </code>
        </a>
       </th>
       <td>
        Whether a value is within a set of values
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="miscellaneous-functions.html#function_inet-aton">
         <code class="literal">
          INET_ATON()
         </code>
        </a>
       </th>
       <td>
        Return the numeric value of an IP address
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="miscellaneous-functions.html#function_inet-ntoa">
         <code class="literal">
          INET_NTOA()
         </code>
        </a>
       </th>
       <td>
        Return the IP address from a numeric value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_insert">
         <code class="literal">
          INSERT()
         </code>
        </a>
       </th>
       <td>
        Insert substring at specified position up to specified number of
      characters
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_instr">
         <code class="literal">
          INSTR()
         </code>
        </a>
       </th>
       <td>
        Return the index of the first occurrence of substring
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-auto-increment">
         <code class="literal">
          INTERNAL_AUTO_INCREMENT()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-avg-row-length">
         <code class="literal">
          INTERNAL_AVG_ROW_LENGTH()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-check-time">
         <code class="literal">
          INTERNAL_CHECK_TIME()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-checksum">
         <code class="literal">
          INTERNAL_CHECKSUM()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-data-free">
         <code class="literal">
          INTERNAL_DATA_FREE()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-data-length">
         <code class="literal">
          INTERNAL_DATA_LENGTH()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-dd-char-length">
         <code class="literal">
          INTERNAL_DD_CHAR_LENGTH()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-get-comment-or-error">
         <code class="literal">
          INTERNAL_GET_COMMENT_OR_ERROR()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-get-enabled-role-json">
         <code class="literal">
          INTERNAL_GET_ENABLED_ROLE_JSON()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-get-hostname">
         <code class="literal">
          INTERNAL_GET_HOSTNAME()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-get-username">
         <code class="literal">
          INTERNAL_GET_USERNAME()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-get-view-warning-or-error">
         <code class="literal">
          INTERNAL_GET_VIEW_WARNING_OR_ERROR()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-index-column-cardinality">
         <code class="literal">
          INTERNAL_INDEX_COLUMN_CARDINALITY()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-index-length">
         <code class="literal">
          INTERNAL_INDEX_LENGTH()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-is-enabled-role">
         <code class="literal">
          INTERNAL_IS_ENABLED_ROLE()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-is-mandatory-role">
         <code class="literal">
          INTERNAL_IS_MANDATORY_ROLE()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-keys-disabled">
         <code class="literal">
          INTERNAL_KEYS_DISABLED()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-max-data-length">
         <code class="literal">
          INTERNAL_MAX_DATA_LENGTH()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-table-rows">
         <code class="literal">
          INTERNAL_TABLE_ROWS()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="internal-functions.html#function_internal-update-time">
         <code class="literal">
          INTERNAL_UPDATE_TIME()
         </code>
        </a>
       </th>
       <td>
        Internal use only
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#function_interval">
         <code class="literal">
          INTERVAL()
         </code>
        </a>
       </th>
       <td>
        Return the index of the argument that is less than the first
      argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_is">
         <code class="literal">
          IS
         </code>
        </a>
       </th>
       <td>
        Test a value against a boolean
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="locking-functions.html#function_is-free-lock">
         <code class="literal">
          IS_FREE_LOCK()
         </code>
        </a>
       </th>
       <td>
        Whether the named lock is free
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_is-not">
         <code class="literal">
          IS NOT
         </code>
        </a>
       </th>
       <td>
        Test a value against a boolean
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_is-not-null">
         <code class="literal">
          IS NOT NULL
         </code>
        </a>
       </th>
       <td>
        NOT NULL value test
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_is-null">
         <code class="literal">
          IS NULL
         </code>
        </a>
       </th>
       <td>
        NULL value test
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="locking-functions.html#function_is-used-lock">
         <code class="literal">
          IS_USED_LOCK()
         </code>
        </a>
       </th>
       <td>
        Whether the named lock is in use; return connection identifier if
      true
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="miscellaneous-functions.html#function_is-uuid">
         <code class="literal">
          IS_UUID()
         </code>
        </a>
       </th>
       <td>
        Whether argument is a valid UUID
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#function_isnull">
         <code class="literal">
          ISNULL()
         </code>
        </a>
       </th>
       <td>
        Test whether the argument is NULL
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-creation-functions.html#function_json-array">
         <code class="literal">
          JSON_ARRAY()
         </code>
        </a>
       </th>
       <td>
        Create JSON array
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-modification-functions.html#function_json-array-append">
         <code class="literal">
          JSON_ARRAY_APPEND()
         </code>
        </a>
       </th>
       <td>
        Append data to JSON document
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-modification-functions.html#function_json-array-insert">
         <code class="literal">
          JSON_ARRAY_INSERT()
         </code>
        </a>
       </th>
       <td>
        Insert into JSON array
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_json-arrayagg">
         <code class="literal">
          JSON_ARRAYAGG()
         </code>
        </a>
       </th>
       <td>
        Return result set as a single JSON array
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-search-functions.html#function_json-contains">
         <code class="literal">
          JSON_CONTAINS()
         </code>
        </a>
       </th>
       <td>
        Whether JSON document contains specific object at path
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-search-functions.html#function_json-contains-path">
         <code class="literal">
          JSON_CONTAINS_PATH()
         </code>
        </a>
       </th>
       <td>
        Whether JSON document contains any data at path
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-attribute-functions.html#function_json-depth">
         <code class="literal">
          JSON_DEPTH()
         </code>
        </a>
       </th>
       <td>
        Maximum depth of JSON document
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-search-functions.html#function_json-extract">
         <code class="literal">
          JSON_EXTRACT()
         </code>
        </a>
       </th>
       <td>
        Return data from JSON document
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-modification-functions.html#function_json-insert">
         <code class="literal">
          JSON_INSERT()
         </code>
        </a>
       </th>
       <td>
        Insert data into JSON document
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-search-functions.html#function_json-keys">
         <code class="literal">
          JSON_KEYS()
         </code>
        </a>
       </th>
       <td>
        Array of keys from JSON document
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-attribute-functions.html#function_json-length">
         <code class="literal">
          JSON_LENGTH()
         </code>
        </a>
       </th>
       <td>
        Number of elements in JSON document
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-modification-functions.html#function_json-merge">
         <code class="literal">
          JSON_MERGE()
         </code>
        </a>
       </th>
       <td>
        Merge JSON documents, preserving duplicate keys. Deprecated
      synonym for JSON_MERGE_PRESERVE()
       </td>
       <td>
        Yes
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-modification-functions.html#function_json-merge-patch">
         <code class="literal">
          JSON_MERGE_PATCH()
         </code>
        </a>
       </th>
       <td>
        Merge JSON documents, replacing values of duplicate keys
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-modification-functions.html#function_json-merge-preserve">
         <code class="literal">
          JSON_MERGE_PRESERVE()
         </code>
        </a>
       </th>
       <td>
        Merge JSON documents, preserving duplicate keys
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-creation-functions.html#function_json-object">
         <code class="literal">
          JSON_OBJECT()
         </code>
        </a>
       </th>
       <td>
        Create JSON object
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_json-objectagg">
         <code class="literal">
          JSON_OBJECTAGG()
         </code>
        </a>
       </th>
       <td>
        Return result set as a single JSON object
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-search-functions.html#function_json-overlaps">
         <code class="literal">
          JSON_OVERLAPS()
         </code>
        </a>
       </th>
       <td>
        Compares two JSON documents, returns TRUE (1) if these have any
      key-value pairs or array elements in common, otherwise FALSE (0)
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-utility-functions.html#function_json-pretty">
         <code class="literal">
          JSON_PRETTY()
         </code>
        </a>
       </th>
       <td>
        Print a JSON document in human-readable format
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-creation-functions.html#function_json-quote">
         <code class="literal">
          JSON_QUOTE()
         </code>
        </a>
       </th>
       <td>
        Quote JSON document
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-modification-functions.html#function_json-remove">
         <code class="literal">
          JSON_REMOVE()
         </code>
        </a>
       </th>
       <td>
        Remove data from JSON document
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-modification-functions.html#function_json-replace">
         <code class="literal">
          JSON_REPLACE()
         </code>
        </a>
       </th>
       <td>
        Replace values in JSON document
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-validation-functions.html#function_json-schema-valid">
         <code class="literal">
          JSON_SCHEMA_VALID()
         </code>
        </a>
       </th>
       <td>
        Validate JSON document against JSON schema; returns TRUE/1 if
      document validates against schema, or FALSE/0 if it does not
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-validation-functions.html#function_json-schema-validation-report">
         <code class="literal">
          JSON_SCHEMA_VALIDATION_REPORT()
         </code>
        </a>
       </th>
       <td>
        Validate JSON document against JSON schema; returns report in JSON
      format on outcome on validation including success or failure and
      reasons for failure
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-search-functions.html#function_json-search">
         <code class="literal">
          JSON_SEARCH()
         </code>
        </a>
       </th>
       <td>
        Path to value within JSON document
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-modification-functions.html#function_json-set">
         <code class="literal">
          JSON_SET()
         </code>
        </a>
       </th>
       <td>
        Insert data into JSON document
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-utility-functions.html#function_json-storage-free">
         <code class="literal">
          JSON_STORAGE_FREE()
         </code>
        </a>
       </th>
       <td>
        Freed space within binary representation of JSON column value
      following partial update
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-utility-functions.html#function_json-storage-size">
         <code class="literal">
          JSON_STORAGE_SIZE()
         </code>
        </a>
       </th>
       <td>
        Space used for storage of binary representation of a JSON document
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-table-functions.html#function_json-table">
         <code class="literal">
          JSON_TABLE()
         </code>
        </a>
       </th>
       <td>
        Return data from a JSON expression as a relational table
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-attribute-functions.html#function_json-type">
         <code class="literal">
          JSON_TYPE()
         </code>
        </a>
       </th>
       <td>
        Type of JSON value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-modification-functions.html#function_json-unquote">
         <code class="literal">
          JSON_UNQUOTE()
         </code>
        </a>
       </th>
       <td>
        Unquote JSON value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-attribute-functions.html#function_json-valid">
         <code class="literal">
          JSON_VALID()
         </code>
        </a>
       </th>
       <td>
        Whether JSON value is valid
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-search-functions.html#function_json-value">
         <code class="literal">
          JSON_VALUE()
         </code>
        </a>
       </th>
       <td>
        Extract value from JSON document at location pointed to by path
      provided; return this value as VARCHAR(512) or specified type
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="window-function-descriptions.html#function_lag">
         <code class="literal">
          LAG()
         </code>
        </a>
       </th>
       <td>
        Value of argument from row lagging current row within partition
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_last-day">
         <code class="literal">
          LAST_DAY
         </code>
        </a>
       </th>
       <td>
        Return the last day of the month for the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_last-insert-id">
         <code class="literal">
          LAST_INSERT_ID()
         </code>
        </a>
       </th>
       <td>
        Value of the AUTOINCREMENT column for the last INSERT
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="window-function-descriptions.html#function_last-value">
         <code class="literal">
          LAST_VALUE()
         </code>
        </a>
       </th>
       <td>
        Value of argument from last row of window frame
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_lcase">
         <code class="literal">
          LCASE()
         </code>
        </a>
       </th>
       <td>
        Synonym for LOWER()
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="window-function-descriptions.html#function_lead">
         <code class="literal">
          LEAD()
         </code>
        </a>
       </th>
       <td>
        Value of argument from row leading current row within partition
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#function_least">
         <code class="literal">
          LEAST()
         </code>
        </a>
       </th>
       <td>
        Return the smallest argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_left">
         <code class="literal">
          LEFT()
         </code>
        </a>
       </th>
       <td>
        Return the leftmost number of characters as specified
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_length">
         <code class="literal">
          LENGTH()
         </code>
        </a>
       </th>
       <td>
        Return the length of a string in bytes
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-comparison-functions.html#operator_like">
         <code class="literal">
          LIKE
         </code>
        </a>
       </th>
       <td>
        Simple pattern matching
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-mysql-specific-functions.html#function_linestring">
         <code class="literal">
          LineString()
         </code>
        </a>
       </th>
       <td>
        Construct LineString from Point values
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_ln">
         <code class="literal">
          LN()
         </code>
        </a>
       </th>
       <td>
        Return the natural logarithm of the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_load-file">
         <code class="literal">
          LOAD_FILE()
         </code>
        </a>
       </th>
       <td>
        Load the named file
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_localtime">
         <code class="literal">
          LOCALTIME()
         </code>
         ,
         <code class="literal">
          LOCALTIME
         </code>
        </a>
       </th>
       <td>
        Synonym for NOW()
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_localtimestamp">
         <code class="literal">
          LOCALTIMESTAMP
         </code>
         ,
         <code class="literal">
          LOCALTIMESTAMP()
         </code>
        </a>
       </th>
       <td>
        Synonym for NOW()
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_locate">
         <code class="literal">
          LOCATE()
         </code>
        </a>
       </th>
       <td>
        Return the position of the first occurrence of substring
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_log">
         <code class="literal">
          LOG()
         </code>
        </a>
       </th>
       <td>
        Return the natural logarithm of the first argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_log10">
         <code class="literal">
          LOG10()
         </code>
        </a>
       </th>
       <td>
        Return the base-10 logarithm of the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_log2">
         <code class="literal">
          LOG2()
         </code>
        </a>
       </th>
       <td>
        Return the base-2 logarithm of the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_lower">
         <code class="literal">
          LOWER()
         </code>
        </a>
       </th>
       <td>
        Return the argument in lowercase
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_lpad">
         <code class="literal">
          LPAD()
         </code>
        </a>
       </th>
       <td>
        Return the string argument, left-padded with the specified string
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_ltrim">
         <code class="literal">
          LTRIM()
         </code>
        </a>
       </th>
       <td>
        Remove leading spaces
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_make-set">
         <code class="literal">
          MAKE_SET()
         </code>
        </a>
       </th>
       <td>
        Return a set of comma-separated strings that have the
      corresponding bit in bits set
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_makedate">
         <code class="literal">
          MAKEDATE()
         </code>
        </a>
       </th>
       <td>
        Create a date from the year and day of year
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_maketime">
         <code class="literal">
          MAKETIME()
         </code>
        </a>
       </th>
       <td>
        Create time from hour, minute, second
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="replication-functions-synchronization.html#function_master-pos-wait">
         <code class="literal">
          MASTER_POS_WAIT()
         </code>
        </a>
       </th>
       <td>
        Block until the replica has read and applied all updates up to the
      specified position
       </td>
       <td>
        Yes
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="fulltext-search.html#function_match">
         <code class="literal">
          MATCH()
         </code>
        </a>
       </th>
       <td>
        Perform full-text search
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_max">
         <code class="literal">
          MAX()
         </code>
        </a>
       </th>
       <td>
        Return the maximum value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-mbr.html#function_mbrcontains">
         <code class="literal">
          MBRContains()
         </code>
        </a>
       </th>
       <td>
        Whether MBR of one geometry contains MBR of another
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-mbr.html#function_mbrcoveredby">
         <code class="literal">
          MBRCoveredBy()
         </code>
        </a>
       </th>
       <td>
        Whether one MBR is covered by another
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-mbr.html#function_mbrcovers">
         <code class="literal">
          MBRCovers()
         </code>
        </a>
       </th>
       <td>
        Whether one MBR covers another
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-mbr.html#function_mbrdisjoint">
         <code class="literal">
          MBRDisjoint()
         </code>
        </a>
       </th>
       <td>
        Whether MBRs of two geometries are disjoint
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-mbr.html#function_mbrequals">
         <code class="literal">
          MBREquals()
         </code>
        </a>
       </th>
       <td>
        Whether MBRs of two geometries are equal
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-mbr.html#function_mbrintersects">
         <code class="literal">
          MBRIntersects()
         </code>
        </a>
       </th>
       <td>
        Whether MBRs of two geometries intersect
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-mbr.html#function_mbroverlaps">
         <code class="literal">
          MBROverlaps()
         </code>
        </a>
       </th>
       <td>
        Whether MBRs of two geometries overlap
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-mbr.html#function_mbrtouches">
         <code class="literal">
          MBRTouches()
         </code>
        </a>
       </th>
       <td>
        Whether MBRs of two geometries touch
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-mbr.html#function_mbrwithin">
         <code class="literal">
          MBRWithin()
         </code>
        </a>
       </th>
       <td>
        Whether MBR of one geometry is within MBR of another
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="encryption-functions.html#function_md5">
         <code class="literal">
          MD5()
         </code>
        </a>
       </th>
       <td>
        Calculate MD5 checksum
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="json-search-functions.html#operator_member-of">
         <code class="literal">
          MEMBER OF()
         </code>
        </a>
       </th>
       <td>
        Returns true (1) if first operand matches any element of JSON
      array passed as second operand, otherwise returns false (0)
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_microsecond">
         <code class="literal">
          MICROSECOND()
         </code>
        </a>
       </th>
       <td>
        Return the microseconds from argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_mid">
         <code class="literal">
          MID()
         </code>
        </a>
       </th>
       <td>
        Return a substring starting from the specified position
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_min">
         <code class="literal">
          MIN()
         </code>
        </a>
       </th>
       <td>
        Return the minimum value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_minute">
         <code class="literal">
          MINUTE()
         </code>
        </a>
       </th>
       <td>
        Return the minute from the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_mod">
         <code class="literal">
          MOD()
         </code>
        </a>
       </th>
       <td>
        Return the remainder
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_month">
         <code class="literal">
          MONTH()
         </code>
        </a>
       </th>
       <td>
        Return the month from the date passed
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_monthname">
         <code class="literal">
          MONTHNAME()
         </code>
        </a>
       </th>
       <td>
        Return the name of the month
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-mysql-specific-functions.html#function_multilinestring">
         <code class="literal">
          MultiLineString()
         </code>
        </a>
       </th>
       <td>
        Contruct MultiLineString from LineString values
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-mysql-specific-functions.html#function_multipoint">
         <code class="literal">
          MultiPoint()
         </code>
        </a>
       </th>
       <td>
        Construct MultiPoint from Point values
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-mysql-specific-functions.html#function_multipolygon">
         <code class="literal">
          MultiPolygon()
         </code>
        </a>
       </th>
       <td>
        Construct MultiPolygon from Polygon values
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="miscellaneous-functions.html#function_name-const">
         <code class="literal">
          NAME_CONST()
         </code>
        </a>
       </th>
       <td>
        Cause the column to have the given name
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="logical-operators.html#operator_not">
         <code class="literal">
          NOT
         </code>
         ,
         <code class="literal">
          !
         </code>
        </a>
       </th>
       <td>
        Negates value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_not-between">
         <code class="literal">
          NOT BETWEEN ... AND ...
         </code>
        </a>
       </th>
       <td>
        Whether a value is not within a range of values
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_not-exists">
         <code class="literal">
          NOT EXISTS()
         </code>
        </a>
       </th>
       <td>
        Whether the result of a query contains no rows
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="comparison-operators.html#operator_not-in">
         <code class="literal">
          NOT IN()
         </code>
        </a>
       </th>
       <td>
        Whether a value is not within a set of values
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-comparison-functions.html#operator_not-like">
         <code class="literal">
          NOT LIKE
         </code>
        </a>
       </th>
       <td>
        Negation of simple pattern matching
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="regexp.html#operator_not-regexp">
         <code class="literal">
          NOT REGEXP
         </code>
        </a>
       </th>
       <td>
        Negation of REGEXP
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_now">
         <code class="literal">
          NOW()
         </code>
        </a>
       </th>
       <td>
        Return the current date and time
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="window-function-descriptions.html#function_nth-value">
         <code class="literal">
          NTH_VALUE()
         </code>
        </a>
       </th>
       <td>
        Value of argument from N-th row of window frame
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="window-function-descriptions.html#function_ntile">
         <code class="literal">
          NTILE()
         </code>
        </a>
       </th>
       <td>
        Bucket number of current row within its partition.
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="flow-control-functions.html#function_nullif">
         <code class="literal">
          NULLIF()
         </code>
        </a>
       </th>
       <td>
        Return NULL if expr1 = expr2
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_oct">
         <code class="literal">
          OCT()
         </code>
        </a>
       </th>
       <td>
        Return a string containing octal representation of a number
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_octet-length">
         <code class="literal">
          OCTET_LENGTH()
         </code>
        </a>
       </th>
       <td>
        Synonym for LENGTH()
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="logical-operators.html#operator_or">
         <code class="literal">
          OR
         </code>
         ,
         <code class="literal">
          ||
         </code>
        </a>
       </th>
       <td>
        Logical OR
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_ord">
         <code class="literal">
          ORD()
         </code>
        </a>
       </th>
       <td>
        Return character code for leftmost character of the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="window-function-descriptions.html#function_percent-rank">
         <code class="literal">
          PERCENT_RANK()
         </code>
        </a>
       </th>
       <td>
        Percentage rank value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_period-add">
         <code class="literal">
          PERIOD_ADD()
         </code>
        </a>
       </th>
       <td>
        Add a period to a year-month
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_period-diff">
         <code class="literal">
          PERIOD_DIFF()
         </code>
        </a>
       </th>
       <td>
        Return the number of months between periods
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_pi">
         <code class="literal">
          PI()
         </code>
        </a>
       </th>
       <td>
        Return the value of pi
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-mysql-specific-functions.html#function_point">
         <code class="literal">
          Point()
         </code>
        </a>
       </th>
       <td>
        Construct Point from coordinates
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-mysql-specific-functions.html#function_polygon">
         <code class="literal">
          Polygon()
         </code>
        </a>
       </th>
       <td>
        Construct Polygon from LineString arguments
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_position">
         <code class="literal">
          POSITION()
         </code>
        </a>
       </th>
       <td>
        Synonym for LOCATE()
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_pow">
         <code class="literal">
          POW()
         </code>
        </a>
       </th>
       <td>
        Return the argument raised to the specified power
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_power">
         <code class="literal">
          POWER()
         </code>
        </a>
       </th>
       <td>
        Return the argument raised to the specified power
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="performance-schema-functions.html#function_ps-current-thread-id">
         <code class="literal">
          PS_CURRENT_THREAD_ID()
         </code>
        </a>
       </th>
       <td>
        Performance Schema thread ID for current thread
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="performance-schema-functions.html#function_ps-thread-id">
         <code class="literal">
          PS_THREAD_ID()
         </code>
        </a>
       </th>
       <td>
        Performance Schema thread ID for given thread
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_quarter">
         <code class="literal">
          QUARTER()
         </code>
        </a>
       </th>
       <td>
        Return the quarter from a date argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_quote">
         <code class="literal">
          QUOTE()
         </code>
        </a>
       </th>
       <td>
        Escape the argument for use in an SQL statement
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_radians">
         <code class="literal">
          RADIANS()
         </code>
        </a>
       </th>
       <td>
        Return argument converted to radians
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_rand">
         <code class="literal">
          RAND()
         </code>
        </a>
       </th>
       <td>
        Return a random floating-point value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="encryption-functions.html#function_random-bytes">
         <code class="literal">
          RANDOM_BYTES()
         </code>
        </a>
       </th>
       <td>
        Return a random byte vector
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="window-function-descriptions.html#function_rank">
         <code class="literal">
          RANK()
         </code>
        </a>
       </th>
       <td>
        Rank of current row within its partition, with gaps
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="regexp.html#operator_regexp">
         <code class="literal">
          REGEXP
         </code>
        </a>
       </th>
       <td>
        Whether string matches regular expression
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="regexp.html#function_regexp-instr">
         <code class="literal">
          REGEXP_INSTR()
         </code>
        </a>
       </th>
       <td>
        Starting index of substring matching regular expression
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="regexp.html#function_regexp-like">
         <code class="literal">
          REGEXP_LIKE()
         </code>
        </a>
       </th>
       <td>
        Whether string matches regular expression
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="regexp.html#function_regexp-replace">
         <code class="literal">
          REGEXP_REPLACE()
         </code>
        </a>
       </th>
       <td>
        Replace substrings matching regular expression
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="regexp.html#function_regexp-substr">
         <code class="literal">
          REGEXP_SUBSTR()
         </code>
        </a>
       </th>
       <td>
        Return substring matching regular expression
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="locking-functions.html#function_release-all-locks">
         <code class="literal">
          RELEASE_ALL_LOCKS()
         </code>
        </a>
       </th>
       <td>
        Release all current named locks
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="locking-functions.html#function_release-lock">
         <code class="literal">
          RELEASE_LOCK()
         </code>
        </a>
       </th>
       <td>
        Release the named lock
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_repeat">
         <code class="literal">
          REPEAT()
         </code>
        </a>
       </th>
       <td>
        Repeat a string the specified number of times
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_replace">
         <code class="literal">
          REPLACE()
         </code>
        </a>
       </th>
       <td>
        Replace occurrences of a specified string
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_reverse">
         <code class="literal">
          REVERSE()
         </code>
        </a>
       </th>
       <td>
        Reverse the characters in a string
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_right">
         <code class="literal">
          RIGHT()
         </code>
        </a>
       </th>
       <td>
        Return the specified rightmost number of characters
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="regexp.html#operator_regexp">
         <code class="literal">
          RLIKE
         </code>
        </a>
       </th>
       <td>
        Whether string matches regular expression
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_roles-graphml">
         <code class="literal">
          ROLES_GRAPHML()
         </code>
        </a>
       </th>
       <td>
        Return a GraphML document representing memory role subgraphs
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_round">
         <code class="literal">
          ROUND()
         </code>
        </a>
       </th>
       <td>
        Round the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_row-count">
         <code class="literal">
          ROW_COUNT()
         </code>
        </a>
       </th>
       <td>
        The number of rows updated
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="window-function-descriptions.html#function_row-number">
         <code class="literal">
          ROW_NUMBER()
         </code>
        </a>
       </th>
       <td>
        Number of current row within its partition
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_rpad">
         <code class="literal">
          RPAD()
         </code>
        </a>
       </th>
       <td>
        Append string the specified number of times
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_rtrim">
         <code class="literal">
          RTRIM()
         </code>
        </a>
       </th>
       <td>
        Remove trailing spaces
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_schema">
         <code class="literal">
          SCHEMA()
         </code>
        </a>
       </th>
       <td>
        Synonym for DATABASE()
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_sec-to-time">
         <code class="literal">
          SEC_TO_TIME()
         </code>
        </a>
       </th>
       <td>
        Converts seconds to 'hh:mm:ss' format
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_second">
         <code class="literal">
          SECOND()
         </code>
        </a>
       </th>
       <td>
        Return the second (0-59)
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_session-user">
         <code class="literal">
          SESSION_USER()
         </code>
        </a>
       </th>
       <td>
        Synonym for USER()
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="encryption-functions.html#function_sha1">
         <code class="literal">
          SHA1()
         </code>
         ,
         <code class="literal">
          SHA()
         </code>
        </a>
       </th>
       <td>
        Calculate an SHA-1 160-bit checksum
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="encryption-functions.html#function_sha2">
         <code class="literal">
          SHA2()
         </code>
        </a>
       </th>
       <td>
        Calculate an SHA-2 checksum
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_sign">
         <code class="literal">
          SIGN()
         </code>
        </a>
       </th>
       <td>
        Return the sign of the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_sin">
         <code class="literal">
          SIN()
         </code>
        </a>
       </th>
       <td>
        Return the sine of the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="miscellaneous-functions.html#function_sleep">
         <code class="literal">
          SLEEP()
         </code>
        </a>
       </th>
       <td>
        Sleep for a number of seconds
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_soundex">
         <code class="literal">
          SOUNDEX()
         </code>
        </a>
       </th>
       <td>
        Return a soundex string
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#operator_sounds-like">
         <code class="literal">
          SOUNDS LIKE
         </code>
        </a>
       </th>
       <td>
        Compare sounds
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="replication-functions-synchronization.html#function_source-pos-wait">
         <code class="literal">
          SOURCE_POS_WAIT()
         </code>
        </a>
       </th>
       <td>
        Block until the replica has read and applied all updates up to the
      specified position
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_space">
         <code class="literal">
          SPACE()
         </code>
        </a>
       </th>
       <td>
        Return a string of the specified number of spaces
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_sqrt">
         <code class="literal">
          SQRT()
         </code>
        </a>
       </th>
       <td>
        Return the square root of the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-polygon-property-functions.html#function_st-area">
         <code class="literal">
          ST_Area()
         </code>
        </a>
       </th>
       <td>
        Return Polygon or MultiPolygon area
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-format-conversion-functions.html#function_st-asbinary">
         <code class="literal">
          ST_AsBinary()
         </code>
         ,
         <code class="literal">
          ST_AsWKB()
         </code>
        </a>
       </th>
       <td>
        Convert from internal geometry format to WKB
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-geojson-functions.html#function_st-asgeojson">
         <code class="literal">
          ST_AsGeoJSON()
         </code>
        </a>
       </th>
       <td>
        Generate GeoJSON object from geometry
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-format-conversion-functions.html#function_st-astext">
         <code class="literal">
          ST_AsText()
         </code>
         ,
         <code class="literal">
          ST_AsWKT()
         </code>
        </a>
       </th>
       <td>
        Convert from internal geometry format to WKT
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-operator-functions.html#function_st-buffer">
         <code class="literal">
          ST_Buffer()
         </code>
        </a>
       </th>
       <td>
        Return geometry of points within given distance from geometry
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-operator-functions.html#function_st-buffer-strategy">
         <code class="literal">
          ST_Buffer_Strategy()
         </code>
        </a>
       </th>
       <td>
        Produce strategy option for ST_Buffer()
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-polygon-property-functions.html#function_st-centroid">
         <code class="literal">
          ST_Centroid()
         </code>
        </a>
       </th>
       <td>
        Return centroid as a point
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-aggregate-functions.html#function_st-collect">
         <code class="literal">
          ST_Collect()
         </code>
        </a>
       </th>
       <td>
        Aggregate spatial values into collection
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-object-shapes.html#function_st-contains">
         <code class="literal">
          ST_Contains()
         </code>
        </a>
       </th>
       <td>
        Whether one geometry contains another
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-operator-functions.html#function_st-convexhull">
         <code class="literal">
          ST_ConvexHull()
         </code>
        </a>
       </th>
       <td>
        Return convex hull of geometry
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-object-shapes.html#function_st-crosses">
         <code class="literal">
          ST_Crosses()
         </code>
        </a>
       </th>
       <td>
        Whether one geometry crosses another
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-operator-functions.html#function_st-difference">
         <code class="literal">
          ST_Difference()
         </code>
        </a>
       </th>
       <td>
        Return point set difference of two geometries
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-general-property-functions.html#function_st-dimension">
         <code class="literal">
          ST_Dimension()
         </code>
        </a>
       </th>
       <td>
        Dimension of geometry
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-object-shapes.html#function_st-disjoint">
         <code class="literal">
          ST_Disjoint()
         </code>
        </a>
       </th>
       <td>
        Whether one geometry is disjoint from another
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-object-shapes.html#function_st-distance">
         <code class="literal">
          ST_Distance()
         </code>
        </a>
       </th>
       <td>
        The distance of one geometry from another
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-convenience-functions.html#function_st-distance-sphere">
         <code class="literal">
          ST_Distance_Sphere()
         </code>
        </a>
       </th>
       <td>
        Minimum distance on earth between two geometries
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-linestring-property-functions.html#function_st-endpoint">
         <code class="literal">
          ST_EndPoint()
         </code>
        </a>
       </th>
       <td>
        End Point of LineString
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-general-property-functions.html#function_st-envelope">
         <code class="literal">
          ST_Envelope()
         </code>
        </a>
       </th>
       <td>
        Return MBR of geometry
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-object-shapes.html#function_st-equals">
         <code class="literal">
          ST_Equals()
         </code>
        </a>
       </th>
       <td>
        Whether one geometry is equal to another
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-polygon-property-functions.html#function_st-exteriorring">
         <code class="literal">
          ST_ExteriorRing()
         </code>
        </a>
       </th>
       <td>
        Return exterior ring of Polygon
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-object-shapes.html#function_st-frechetdistance">
         <code class="literal">
          ST_FrechetDistance()
         </code>
        </a>
       </th>
       <td>
        The discrete Fréchet distance of one geometry from another
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-geohash-functions.html#function_st-geohash">
         <code class="literal">
          ST_GeoHash()
         </code>
        </a>
       </th>
       <td>
        Produce a geohash value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-wkt-functions.html#function_st-geomcollfromtext">
         <code class="literal">
          ST_GeomCollFromText()
         </code>
         ,
         <code class="literal">
          ST_GeometryCollectionFromText()
         </code>
         ,
         <code class="literal">
          ST_GeomCollFromTxt()
         </code>
        </a>
       </th>
       <td>
        Return geometry collection from WKT
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-wkb-functions.html#function_st-geomcollfromwkb">
         <code class="literal">
          ST_GeomCollFromWKB()
         </code>
         ,
         <code class="literal">
          ST_GeometryCollectionFromWKB()
         </code>
        </a>
       </th>
       <td>
        Return geometry collection from WKB
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-geometrycollection-property-functions.html#function_st-geometryn">
         <code class="literal">
          ST_GeometryN()
         </code>
        </a>
       </th>
       <td>
        Return N-th geometry from geometry collection
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-general-property-functions.html#function_st-geometrytype">
         <code class="literal">
          ST_GeometryType()
         </code>
        </a>
       </th>
       <td>
        Return name of geometry type
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-geojson-functions.html#function_st-geomfromgeojson">
         <code class="literal">
          ST_GeomFromGeoJSON()
         </code>
        </a>
       </th>
       <td>
        Generate geometry from GeoJSON object
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-wkt-functions.html#function_st-geomfromtext">
         <code class="literal">
          ST_GeomFromText()
         </code>
         ,
         <code class="literal">
          ST_GeometryFromText()
         </code>
        </a>
       </th>
       <td>
        Return geometry from WKT
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-wkb-functions.html#function_st-geomfromwkb">
         <code class="literal">
          ST_GeomFromWKB()
         </code>
         ,
         <code class="literal">
          ST_GeometryFromWKB()
         </code>
        </a>
       </th>
       <td>
        Return geometry from WKB
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-object-shapes.html#function_st-hausdorffdistance">
         <code class="literal">
          ST_HausdorffDistance()
         </code>
        </a>
       </th>
       <td>
        The discrete Hausdorff distance of one geometry from another
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-polygon-property-functions.html#function_st-interiorringn">
         <code class="literal">
          ST_InteriorRingN()
         </code>
        </a>
       </th>
       <td>
        Return N-th interior ring of Polygon
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-operator-functions.html#function_st-intersection">
         <code class="literal">
          ST_Intersection()
         </code>
        </a>
       </th>
       <td>
        Return point set intersection of two geometries
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-object-shapes.html#function_st-intersects">
         <code class="literal">
          ST_Intersects()
         </code>
        </a>
       </th>
       <td>
        Whether one geometry intersects another
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-linestring-property-functions.html#function_st-isclosed">
         <code class="literal">
          ST_IsClosed()
         </code>
        </a>
       </th>
       <td>
        Whether a geometry is closed and simple
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-general-property-functions.html#function_st-isempty">
         <code class="literal">
          ST_IsEmpty()
         </code>
        </a>
       </th>
       <td>
        Whether a geometry is empty
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-general-property-functions.html#function_st-issimple">
         <code class="literal">
          ST_IsSimple()
         </code>
        </a>
       </th>
       <td>
        Whether a geometry is simple
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-convenience-functions.html#function_st-isvalid">
         <code class="literal">
          ST_IsValid()
         </code>
        </a>
       </th>
       <td>
        Whether a geometry is valid
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-geohash-functions.html#function_st-latfromgeohash">
         <code class="literal">
          ST_LatFromGeoHash()
         </code>
        </a>
       </th>
       <td>
        Return latitude from geohash value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-point-property-functions.html#function_st-latitude">
         <code class="literal">
          ST_Latitude()
         </code>
        </a>
       </th>
       <td>
        Return latitude of Point
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-linestring-property-functions.html#function_st-length">
         <code class="literal">
          ST_Length()
         </code>
        </a>
       </th>
       <td>
        Return length of LineString
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-wkt-functions.html#function_st-linefromtext">
         <code class="literal">
          ST_LineFromText()
         </code>
         ,
         <code class="literal">
          ST_LineStringFromText()
         </code>
        </a>
       </th>
       <td>
        Construct LineString from WKT
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-wkb-functions.html#function_st-linefromwkb">
         <code class="literal">
          ST_LineFromWKB()
         </code>
         ,
         <code class="literal">
          ST_LineStringFromWKB()
         </code>
        </a>
       </th>
       <td>
        Construct LineString from WKB
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-operator-functions.html#function_st-lineinterpolatepoint">
         <code class="literal">
          ST_LineInterpolatePoint()
         </code>
        </a>
       </th>
       <td>
        The point a given percentage along a LineString
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-operator-functions.html#function_st-lineinterpolatepoints">
         <code class="literal">
          ST_LineInterpolatePoints()
         </code>
        </a>
       </th>
       <td>
        The points a given percentage along a LineString
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-geohash-functions.html#function_st-longfromgeohash">
         <code class="literal">
          ST_LongFromGeoHash()
         </code>
        </a>
       </th>
       <td>
        Return longitude from geohash value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-point-property-functions.html#function_st-longitude">
         <code class="literal">
          ST_Longitude()
         </code>
        </a>
       </th>
       <td>
        Return longitude of Point
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-convenience-functions.html#function_st-makeenvelope">
         <code class="literal">
          ST_MakeEnvelope()
         </code>
        </a>
       </th>
       <td>
        Rectangle around two points
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-wkt-functions.html#function_st-mlinefromtext">
         <code class="literal">
          ST_MLineFromText()
         </code>
         ,
         <code class="literal">
          ST_MultiLineStringFromText()
         </code>
        </a>
       </th>
       <td>
        Construct MultiLineString from WKT
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-wkb-functions.html#function_st-mlinefromwkb">
         <code class="literal">
          ST_MLineFromWKB()
         </code>
         ,
         <code class="literal">
          ST_MultiLineStringFromWKB()
         </code>
        </a>
       </th>
       <td>
        Construct MultiLineString from WKB
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-wkt-functions.html#function_st-mpointfromtext">
         <code class="literal">
          ST_MPointFromText()
         </code>
         ,
         <code class="literal">
          ST_MultiPointFromText()
         </code>
        </a>
       </th>
       <td>
        Construct MultiPoint from WKT
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-wkb-functions.html#function_st-mpointfromwkb">
         <code class="literal">
          ST_MPointFromWKB()
         </code>
         ,
         <code class="literal">
          ST_MultiPointFromWKB()
         </code>
        </a>
       </th>
       <td>
        Construct MultiPoint from WKB
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-wkt-functions.html#function_st-mpolyfromtext">
         <code class="literal">
          ST_MPolyFromText()
         </code>
         ,
         <code class="literal">
          ST_MultiPolygonFromText()
         </code>
        </a>
       </th>
       <td>
        Construct MultiPolygon from WKT
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-wkb-functions.html#function_st-mpolyfromwkb">
         <code class="literal">
          ST_MPolyFromWKB()
         </code>
         ,
         <code class="literal">
          ST_MultiPolygonFromWKB()
         </code>
        </a>
       </th>
       <td>
        Construct MultiPolygon from WKB
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-geometrycollection-property-functions.html#function_st-numgeometries">
         <code class="literal">
          ST_NumGeometries()
         </code>
        </a>
       </th>
       <td>
        Return number of geometries in geometry collection
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-polygon-property-functions.html#function_st-numinteriorrings">
         <code class="literal">
          ST_NumInteriorRing()
         </code>
         ,
         <code class="literal">
          ST_NumInteriorRings()
         </code>
        </a>
       </th>
       <td>
        Return number of interior rings in Polygon
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-linestring-property-functions.html#function_st-numpoints">
         <code class="literal">
          ST_NumPoints()
         </code>
        </a>
       </th>
       <td>
        Return number of points in LineString
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-object-shapes.html#function_st-overlaps">
         <code class="literal">
          ST_Overlaps()
         </code>
        </a>
       </th>
       <td>
        Whether one geometry overlaps another
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-operator-functions.html#function_st-pointatdistance">
         <code class="literal">
          ST_PointAtDistance()
         </code>
        </a>
       </th>
       <td>
        The point a given distance along a LineString
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-geohash-functions.html#function_st-pointfromgeohash">
         <code class="literal">
          ST_PointFromGeoHash()
         </code>
        </a>
       </th>
       <td>
        Convert geohash value to POINT value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-wkt-functions.html#function_st-pointfromtext">
         <code class="literal">
          ST_PointFromText()
         </code>
        </a>
       </th>
       <td>
        Construct Point from WKT
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-wkb-functions.html#function_st-pointfromwkb">
         <code class="literal">
          ST_PointFromWKB()
         </code>
        </a>
       </th>
       <td>
        Construct Point from WKB
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-linestring-property-functions.html#function_st-pointn">
         <code class="literal">
          ST_PointN()
         </code>
        </a>
       </th>
       <td>
        Return N-th point from LineString
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-wkt-functions.html#function_st-polyfromtext">
         <code class="literal">
          ST_PolyFromText()
         </code>
         ,
         <code class="literal">
          ST_PolygonFromText()
         </code>
        </a>
       </th>
       <td>
        Construct Polygon from WKT
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-wkb-functions.html#function_st-polyfromwkb">
         <code class="literal">
          ST_PolyFromWKB()
         </code>
         ,
         <code class="literal">
          ST_PolygonFromWKB()
         </code>
        </a>
       </th>
       <td>
        Construct Polygon from WKB
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-convenience-functions.html#function_st-simplify">
         <code class="literal">
          ST_Simplify()
         </code>
        </a>
       </th>
       <td>
        Return simplified geometry
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-general-property-functions.html#function_st-srid">
         <code class="literal">
          ST_SRID()
         </code>
        </a>
       </th>
       <td>
        Return spatial reference system ID for geometry
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-linestring-property-functions.html#function_st-startpoint">
         <code class="literal">
          ST_StartPoint()
         </code>
        </a>
       </th>
       <td>
        Start Point of LineString
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-format-conversion-functions.html#function_st-swapxy">
         <code class="literal">
          ST_SwapXY()
         </code>
        </a>
       </th>
       <td>
        Return argument with X/Y coordinates swapped
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-operator-functions.html#function_st-symdifference">
         <code class="literal">
          ST_SymDifference()
         </code>
        </a>
       </th>
       <td>
        Return point set symmetric difference of two geometries
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-object-shapes.html#function_st-touches">
         <code class="literal">
          ST_Touches()
         </code>
        </a>
       </th>
       <td>
        Whether one geometry touches another
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-operator-functions.html#function_st-transform">
         <code class="literal">
          ST_Transform()
         </code>
        </a>
       </th>
       <td>
        Transform coordinates of geometry
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-operator-functions.html#function_st-union">
         <code class="literal">
          ST_Union()
         </code>
        </a>
       </th>
       <td>
        Return point set union of two geometries
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-convenience-functions.html#function_st-validate">
         <code class="literal">
          ST_Validate()
         </code>
        </a>
       </th>
       <td>
        Return validated geometry
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="spatial-relation-functions-object-shapes.html#function_st-within">
         <code class="literal">
          ST_Within()
         </code>
        </a>
       </th>
       <td>
        Whether one geometry is within another
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-point-property-functions.html#function_st-x">
         <code class="literal">
          ST_X()
         </code>
        </a>
       </th>
       <td>
        Return X coordinate of Point
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gis-point-property-functions.html#function_st-y">
         <code class="literal">
          ST_Y()
         </code>
        </a>
       </th>
       <td>
        Return Y coordinate of Point
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="encryption-functions.html#function_statement-digest">
         <code class="literal">
          STATEMENT_DIGEST()
         </code>
        </a>
       </th>
       <td>
        Compute statement digest hash value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="encryption-functions.html#function_statement-digest-text">
         <code class="literal">
          STATEMENT_DIGEST_TEXT()
         </code>
        </a>
       </th>
       <td>
        Compute normalized statement digest
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_std">
         <code class="literal">
          STD()
         </code>
        </a>
       </th>
       <td>
        Return the population standard deviation
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_stddev">
         <code class="literal">
          STDDEV()
         </code>
        </a>
       </th>
       <td>
        Return the population standard deviation
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_stddev-pop">
         <code class="literal">
          STDDEV_POP()
         </code>
        </a>
       </th>
       <td>
        Return the population standard deviation
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_stddev-samp">
         <code class="literal">
          STDDEV_SAMP()
         </code>
        </a>
       </th>
       <td>
        Return the sample standard deviation
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_str-to-date">
         <code class="literal">
          STR_TO_DATE()
         </code>
        </a>
       </th>
       <td>
        Convert a string to a date
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-comparison-functions.html#function_strcmp">
         <code class="literal">
          STRCMP()
         </code>
        </a>
       </th>
       <td>
        Compare two strings
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_subdate">
         <code class="literal">
          SUBDATE()
         </code>
        </a>
       </th>
       <td>
        Synonym for DATE_SUB() when invoked with three arguments
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_substr">
         <code class="literal">
          SUBSTR()
         </code>
        </a>
       </th>
       <td>
        Return the substring as specified
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_substring">
         <code class="literal">
          SUBSTRING()
         </code>
        </a>
       </th>
       <td>
        Return the substring as specified
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_substring-index">
         <code class="literal">
          SUBSTRING_INDEX()
         </code>
        </a>
       </th>
       <td>
        Return a substring from a string before the specified number of
      occurrences of the delimiter
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_subtime">
         <code class="literal">
          SUBTIME()
         </code>
        </a>
       </th>
       <td>
        Subtract times
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_sum">
         <code class="literal">
          SUM()
         </code>
        </a>
       </th>
       <td>
        Return the sum
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_sysdate">
         <code class="literal">
          SYSDATE()
         </code>
        </a>
       </th>
       <td>
        Return the time at which the function executes
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_system-user">
         <code class="literal">
          SYSTEM_USER()
         </code>
        </a>
       </th>
       <td>
        Synonym for USER()
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_tan">
         <code class="literal">
          TAN()
         </code>
        </a>
       </th>
       <td>
        Return the tangent of the argument
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_time">
         <code class="literal">
          TIME()
         </code>
        </a>
       </th>
       <td>
        Extract the time portion of the expression passed
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_time-format">
         <code class="literal">
          TIME_FORMAT()
         </code>
        </a>
       </th>
       <td>
        Format as time
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_time-to-sec">
         <code class="literal">
          TIME_TO_SEC()
         </code>
        </a>
       </th>
       <td>
        Return the argument converted to seconds
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_timediff">
         <code class="literal">
          TIMEDIFF()
         </code>
        </a>
       </th>
       <td>
        Subtract time
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_timestamp">
         <code class="literal">
          TIMESTAMP()
         </code>
        </a>
       </th>
       <td>
        With a single argument, this function returns the date or datetime
      expression; with two arguments, the sum of the arguments
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_timestampadd">
         <code class="literal">
          TIMESTAMPADD()
         </code>
        </a>
       </th>
       <td>
        Add an interval to a datetime expression
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_timestampdiff">
         <code class="literal">
          TIMESTAMPDIFF()
         </code>
        </a>
       </th>
       <td>
        Return the difference of two datetime expressions, using the units
      specified
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_to-days">
         <code class="literal">
          TO_DAYS()
         </code>
        </a>
       </th>
       <td>
        Return the date argument converted to days
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_to-seconds">
         <code class="literal">
          TO_SECONDS()
         </code>
        </a>
       </th>
       <td>
        Return the date or datetime argument converted to seconds since
      Year 0
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_trim">
         <code class="literal">
          TRIM()
         </code>
        </a>
       </th>
       <td>
        Remove leading and trailing spaces
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mathematical-functions.html#function_truncate">
         <code class="literal">
          TRUNCATE()
         </code>
        </a>
       </th>
       <td>
        Truncate to specified number of decimal places
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_ucase">
         <code class="literal">
          UCASE()
         </code>
        </a>
       </th>
       <td>
        Synonym for UPPER()
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="encryption-functions.html#function_uncompress">
         <code class="literal">
          UNCOMPRESS()
         </code>
        </a>
       </th>
       <td>
        Uncompress a string compressed
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="encryption-functions.html#function_uncompressed-length">
         <code class="literal">
          UNCOMPRESSED_LENGTH()
         </code>
        </a>
       </th>
       <td>
        Return the length of a string before compression
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_unhex">
         <code class="literal">
          UNHEX()
         </code>
        </a>
       </th>
       <td>
        Return a string containing hex representation of a number
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_unix-timestamp">
         <code class="literal">
          UNIX_TIMESTAMP()
         </code>
        </a>
       </th>
       <td>
        Return a Unix timestamp
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="xml-functions.html#function_updatexml">
         <code class="literal">
          UpdateXML()
         </code>
        </a>
       </th>
       <td>
        Return replaced XML fragment
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_upper">
         <code class="literal">
          UPPER()
         </code>
        </a>
       </th>
       <td>
        Convert to uppercase
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_user">
         <code class="literal">
          USER()
         </code>
        </a>
       </th>
       <td>
        The user name and host name provided by the client
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_utc-date">
         <code class="literal">
          UTC_DATE()
         </code>
        </a>
       </th>
       <td>
        Return the current UTC date
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_utc-time">
         <code class="literal">
          UTC_TIME()
         </code>
        </a>
       </th>
       <td>
        Return the current UTC time
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_utc-timestamp">
         <code class="literal">
          UTC_TIMESTAMP()
         </code>
        </a>
       </th>
       <td>
        Return the current UTC date and time
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="miscellaneous-functions.html#function_uuid">
         <code class="literal">
          UUID()
         </code>
        </a>
       </th>
       <td>
        Return a Universal Unique Identifier (UUID)
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="miscellaneous-functions.html#function_uuid-short">
         <code class="literal">
          UUID_SHORT()
         </code>
        </a>
       </th>
       <td>
        Return an integer-valued universal identifier
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="miscellaneous-functions.html#function_uuid-to-bin">
         <code class="literal">
          UUID_TO_BIN()
         </code>
        </a>
       </th>
       <td>
        Convert string UUID to binary
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="encryption-functions.html#function_validate-password-strength">
         <code class="literal">
          VALIDATE_PASSWORD_STRENGTH()
         </code>
        </a>
       </th>
       <td>
        Determine strength of password
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="miscellaneous-functions.html#function_values">
         <code class="literal">
          VALUES()
         </code>
        </a>
       </th>
       <td>
        Define the values to be used during an INSERT
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_var-pop">
         <code class="literal">
          VAR_POP()
         </code>
        </a>
       </th>
       <td>
        Return the population standard variance
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_var-samp">
         <code class="literal">
          VAR_SAMP()
         </code>
        </a>
       </th>
       <td>
        Return the sample variance
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="aggregate-functions.html#function_variance">
         <code class="literal">
          VARIANCE()
         </code>
        </a>
       </th>
       <td>
        Return the population standard variance
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="information-functions.html#function_version">
         <code class="literal">
          VERSION()
         </code>
        </a>
       </th>
       <td>
        Return a string that indicates the MySQL server version
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="gtid-functions.html#function_wait-for-executed-gtid-set">
         <code class="literal">
          WAIT_FOR_EXECUTED_GTID_SET()
         </code>
        </a>
       </th>
       <td>
        Wait until the given GTIDs have executed on the replica.
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_week">
         <code class="literal">
          WEEK()
         </code>
        </a>
       </th>
       <td>
        Return the week number
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_weekday">
         <code class="literal">
          WEEKDAY()
         </code>
        </a>
       </th>
       <td>
        Return the weekday index
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_weekofyear">
         <code class="literal">
          WEEKOFYEAR()
         </code>
        </a>
       </th>
       <td>
        Return the calendar week of the date (1-53)
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="string-functions.html#function_weight-string">
         <code class="literal">
          WEIGHT_STRING()
         </code>
        </a>
       </th>
       <td>
        Return the weight string for a string
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="logical-operators.html#operator_xor">
         <code class="literal">
          XOR
         </code>
        </a>
       </th>
       <td>
        Logical XOR
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_year">
         <code class="literal">
          YEAR()
         </code>
        </a>
       </th>
       <td>
        Return the year
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="date-and-time-functions.html#function_yearweek">
         <code class="literal">
          YEARWEEK()
         </code>
        </a>
       </th>
       <td>
        Return the year and week
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="bit-functions.html#operator_bitwise-or">
         <code class="literal">
          |
         </code>
        </a>
       </th>
       <td>
        Bitwise OR
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="bit-functions.html#operator_bitwise-invert">
         <code class="literal">
          ~
         </code>
        </a>
       </th>
       <td>
        Bitwise inversion
       </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: 405.156px;">
        Name
       </th>
       <th style="width: 243.688px;">
        Description
       </th>
       <th style="width: 89.1562px;">
        Deprecated
       </th>
      </tr>
     </thead>
    </table>
   </div>
  </div>
  <br class="table-break"/>
 </div>
 <br/>
</div>
