Operators

Amazon S3 Select and S3 Glacier 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