Content adapted from W3Schools.
Comparison Operators
| Operator | Description | Logic Symbol |
|---|
= | Equal to | = |
> | Greater than | > |
< | Less than | < |
>= | Greater than or equal to | ≥ |
<= | Less than or equal to | ≤ |
<> | Not equal to | ≠ |
Bitwise Operators
| Operator | Description | Logic Symbol |
|---|
& | Bitwise AND | ⋅ |
| | Bitwise OR; inclusive disjunction | ∨ |
^ | Bitwise exclusive OR; exclusive disjunction | ⇎ or ⊕ |
Logical Operators
| Operator | Description | Logic Symbol |
|---|
ALL | TRUE if all subquery values meet the condition | ∀ |
AND | TRUE if all conditions are TRUE | ⋅ |
ANY | TRUE if any subquery value meets the condition | ∃ |
BETWEEN | TRUE if operand is within a range | |
EXISTS | TRUE if subquery returns one or more records | ∃ |
IN | TRUE if operand equals one of a list of values | |
LIKE | TRUE if operand matches a pattern | |
NOT | TRUE if condition(s) is NOT TRUE | ~ |
OR | TRUE if any condition is TRUE | ∨ |
SOME | TRUE if any subquery value meets the condition | ∃ |
Arithmetic Operators
| Operator | Description |
|---|
+ | Add |
- | Subtract |
* | Multiply |
/ | Divide |
% | Modulo |
Compound Operators
| Operator | Description | Usage |
|---|
+= | Shorthand for x = x + 5 | Adds a value to a variable and assigns the result back to the variable. Used to increment a value in place. |
-= | Shorthand for x = x - 3 | Subtracts a value from a variable and assigns the result back. Used to decrement a value. |
*= | Shorthand for x = x * 2 | Multiplies a variable by a value and assigns the result back. Used to scale values. |
/= | Shorthand for x = x / 4 | Divides a variable by a value and assigns the result back. Used to reduce values proportionally. |
%= | Shorthand for x = x % 10 | Gets the remainder when dividing and assigns it back. Used for cyclic operations like wrapping numbers. |
&= | Shorthand for x = x & 0xFF | Used to clear specific bits or extract bit patterns from binary data. |
^= | Shorthand for x = x ^ 0x01 | Used to toggle or flip specific bits. |
|*= | Shorthand for x = x | 0x80 | Used to set specific bits to 1 while preserving others. |
