<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="non-typed-operators">
      </a>
      14.4 Operators
     </h2>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="operator-precedence.html">
       14.4.1 Operator Precedence
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="comparison-operators.html">
       14.4.2 Comparison Functions and Operators
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="logical-operators.html">
       14.4.3 Logical Operators
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="assignment-operators.html">
       14.4.4 Assignment Operators
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <div class="table">
   <a name="idm46045207782080">
   </a>
   <p class="title">
    <b>
     Table 14.3 Operators
    </b>
   </p>
   <div class="table-contents">
    <table frame="box" rules="all" summary="A reference that lists all 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="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="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="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="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="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="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="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="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="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="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="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="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="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="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#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="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="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="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: 186.203px;">
        Name
       </th>
       <th style="width: 461.797px;">
        Description
       </th>
       <th style="width: 90px;">
        Deprecated
       </th>
      </tr>
     </thead>
    </table>
   </div>
  </div>
  <br class="table-break"/>
 </div>
 <br/>
</div>
