2.10.2.5.8. JPQL Operators and Operator Precedence

The operators are listed below in order of decreasing precedence.

  • Navigation operator (.)

  • Arithmetic operators: +, - unary *, / multiplication and division +, - addition and subtraction. Operators of equal precedence are evaluated from left to right.

  • String concatenation (||)

  • Comparison operators: =, , =, , =, (not equal), [ NOT ] BETWEEN, [ NOT ] LIKE, [ NOT ] IN, IS [ NOT ] NULL, IS [ NOT ] EMPTY, [ NOT ] MEMBER [ OF ]

  • Logical operators: NOT, AND, OR

The following sections describe other operators used in specific expressions.