Operators - Amazon Simple Storage Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China.

Operators

Amazon S3 Select support the following operators.

Logical Operators

  • AND

  • NOT

  • OR

Comparison Operators

  • <

  • >

  • <=

  • >=

  • =

  • <>

  • !=

  • BETWEEN

  • IN – For example: IN ('a', 'b', 'c')

Pattern Matching Operators

  • LIKE

  • _ (Matches any character)

  • % (Matches any sequence of characters)

Unitary Operators

  • IS NULL

  • IS NOT NULL

Math Operators

Addition, subtraction, multiplication, division, and modulo are supported.

  • +

  • -

  • *

  • /

  • %

Operator Precedence

The following table shows the operators' precedence in decreasing order.

Operator/Element Associativity Required
- right unary minus
*, /, % left multiplication, division, modulo
+, - left addition, subtraction
IN set membership
BETWEEN range containment
LIKE string pattern matching
<> less than, greater than
= right equality, assignment
NOT right logical negation
AND left logical conjunction
OR left logical disjunction