site/docs/3.4.3/generated-predicate-funcs-table.html

<table class="table">
  <thead>
    <tr>
      <th style="width:25%">Function</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>! expr</td>
      <td>Logical not.</td>
    </tr>
    <tr>
      <td>expr1 < expr2</td>
      <td>Returns true if `expr1` is less than `expr2`.</td>
    </tr>
    <tr>
      <td>expr1 <= expr2</td>
      <td>Returns true if `expr1` is less than or equal to `expr2`.</td>
    </tr>
    <tr>
      <td>expr1 <=> expr2</td>
      <td>Returns same result as the EQUAL(=) operator for non-null operands,
      but returns true if both are null, false if one of the them is null.</td>
    </tr>
    <tr>
      <td>expr1 = expr2</td>
      <td>Returns true if `expr1` equals `expr2`, or false otherwise.</td>
    </tr>
    <tr>
      <td>expr1 == expr2</td>
      <td>Returns true if `expr1` equals `expr2`, or false otherwise.</td>
    </tr>
    <tr>
      <td>expr1 > expr2</td>
      <td>Returns true if `expr1` is greater than `expr2`.</td>
    </tr>
    <tr>
      <td>expr1 >= expr2</td>
      <td>Returns true if `expr1` is greater than or equal to `expr2`.</td>
    </tr>
    <tr>
      <td>expr1 and expr2</td>
      <td>Logical AND.</td>
    </tr>
    <tr>
      <td>str ilike pattern[ ESCAPE escape]</td>
      <td>Returns true if str matches `pattern` with `escape` case-insensitively, null if any arguments are null, false otherwise.</td>
    </tr>
    <tr>
      <td>expr1 in(expr2, expr3, ...)</td>
      <td>Returns true if `expr` equals to any valN.</td>
    </tr>
    <tr>
      <td>isnan(expr)</td>
      <td>Returns true if `expr` is NaN, or false otherwise.</td>
    </tr>
    <tr>
      <td>isnotnull(expr)</td>
      <td>Returns true if `expr` is not null, or false otherwise.</td>
    </tr>
    <tr>
      <td>isnull(expr)</td>
      <td>Returns true if `expr` is null, or false otherwise.</td>
    </tr>
    <tr>
      <td>str like pattern[ ESCAPE escape]</td>
      <td>Returns true if str matches `pattern` with `escape`, null if any arguments are null, false otherwise.</td>
    </tr>
    <tr>
      <td>not expr</td>
      <td>Logical not.</td>
    </tr>
    <tr>
      <td>expr1 or expr2</td>
      <td>Logical OR.</td>
    </tr>
    <tr>
      <td>regexp(str, regexp)</td>
      <td>Returns true if `str` matches `regexp`, or false otherwise.</td>
    </tr>
    <tr>
      <td>regexp_like(str, regexp)</td>
      <td>Returns true if `str` matches `regexp`, or false otherwise.</td>
    </tr>
    <tr>
      <td>rlike(str, regexp)</td>
      <td>Returns true if `str` matches `regexp`, or false otherwise.</td>
    </tr>
  </tbody>
</table>