Relational Operators Back | Forward | Home

'Language Reference'
  • Logical Operators

  • Relational Operators

  • Data Types

  • Column Types

  • Primary Keys

  • Functions

  • Where Clauses

  • LIKE Clauses

  • Limit Clauses

  • OrderBy Clauses

  • Notes


  • User Functions

    Database Functions

    Data Manipulation Functions

    Table Functions

    Error Handling Functions

    << Last Section ( Logical Operators ) Relational Operators Next Section ( Data Types ) >>

    These operators can be used in constructing a where clause

    Example Name Result
    array('$a = $b') equal to TRUE if $a is equal to $b
    array('$a != $b') not equal to TRUE if $a is not equal to $b
    array('$a <> $b') not equal to TRUE if $a is not equal to $b
    array('$a < $b') less than TRUE if $a is less than $b
    array('$a <= '$b') less than or equal to TRUE if $a is less than or equal to $b
    array('$a > $b') greater than TRUE if $a is greater than $b
    array('$a >= $b') greater than or equal to TRUE if $a is greater than or equal to $b
    array('$a =~ $b') like TRUE if $a matches the pattern $b. Also see: LIKE clauses
    array('$a !~ $b') not like TRUE if $a does _NOT_ match the pattern $b.
    array('$a ? $b') instring (txtSQL >= 2.2.2 RC2) TRUE if $b is in $a
    array('$a !? $b') not instring (txtSQL >= 2.2.2 RC2) TRUE if $b is NOT in $a


    User-Contributed Comments for:
    Relational Operators
    No comments found;