Operators - Amazon Simple Storage Service
Logical operators Comparison operators Pattern-matching operators Unitary operators Math operators Operator precedence
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 (PDF).

Operators

Amazon S3 Select supports 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, as follows:

  • +

  • -

  • *

  • /

  • %

Operator precedence

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

Operator or 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