# **Operator Overview**

## [**Arithmetic operator**](arithmetic-operators/arithmetic-operators-overview.md)

| Name | Description |
|---|----|
| [%,MOD](arithmetic-operators/mod.md) | Take the rest |
| [*](arithmetic-operators/multiplication.md) | Multiplication |
| [+](arithmetic-operators/addition.md) | Addition |
| [-](arithmetic-operators/minus.md) | Subtraction |
| [-](arithmetic-operators/unary-minus.md) | minus sign |
| [/](arithmetic-operators/division.md) | Division |
| [DIV](arithmetic-operators/div.md) | For integer division |

## [**Assignment operator**](assignment-operators/assignment-operators-overview.md)

| Name | Description |
|---|----|
| [=](assignment-operators/equal.md) | equal operator, used for assignment |

## [**Binary Operator**](bit-functions-and-operators/bit-functions-and-operators-overview.md)

| Name | Description |
|---|----|
| [&](bit-functions-and-operators/bitwise-and.md) | bit operator and, bitwise and |
| [>>](bit-functions-and-operators/right-shift.md) | Shift the displacement operator right |
| [<<](bit-functions-and-operators/left-shift.md) |Distance operator shift left |
| [^](bit-functions-and-operators/bitwise-xor.md) |Bitwise XOR |
| [\|](bit-functions-and-operators/bitwise-or.md) |bit operator or, bitwise or|
| [~](bit-functions-and-operators/bitwise-inversion.md) |Unary operator, binary inversion |

## [**Cast function and operator**](cast-functions-and-operators/cast-functions-and-operators-overview.md)

| Name | Description |
|---|----|
| [BINARY()](cast-functions-and-operators/binary.md) | Functions that convert values to binary strings |
| [CAST()](cast-functions-and-operators/cast.md) | Convert values to specific types for decimal values and character types |
| [CONVERT()](cast-functions-and-operators/convert.md) | Convert values to specific types for conversion between date and time values and decimals |

## [**Comparison functions and operators**](comparison-functions-and-operators/comparison-functions-and-operators-overview.md)

| Name | Description |
|---|----|
| [>](comparison-functions-and-operators/greater-than.md) | greater than |
| [>=](comparison-functions-and-operators/greater-than-or-equal.md) | greater than or equal to |
| [<](comparison-functions-and-operators/less-than.md) | Less than |
| [<>,!=](comparison-functions-and-operators/not-equal.md) | Not equal |
| [<=](comparison-functions-and-operators/less-than-or-equal.md) | Less than or equal to |
| [=](comparison-functions-and-operators/assign-equal.md) | equals |
| [BETWEEN ... AND ...](comparison-functions-and-operators/between.md) | Between two values |
| [IN()](comparison-functions-and-operators/in.md) | In the collection |
| [IS](comparison-functions-and-operators/is.md) | Test whether the value is a Boolean value. If it is a Boolean value, it returns "true" |
| [IS NOT](comparison-functions-and-operators/is-not.md) | Test whether the value is a boolean value, negative usage of IS |
| [IS NOT NULL](comparison-functions-and-operators/is-not-null.md) | Not empty |
| [IS NULL](comparison-functions-and-operators/is-null.md) | empty |
| [ISNULL](comparison-functions-and-operators/function_isnull.md) | Use instead of `=` to test whether the value is `NULL`. |
| [LIKE](comparison-functions-and-operators/like.md) | Fuzzy matching |
| [ILIKE](comparison-functions-and-operators/ilike.md) | Fuzzy matching, same as LIKE. But it is not case sensitive. |
| [NOT BETWEEN ... AND ...](comparison-functions-and-operators/not-between.md) | Not between two values |
| [NOT IN](comparison-functions-and-operators/not-in.md) | Abbreviation of multiple `XOR` conditions |
| [NOT LIKE](comparison-functions-and-operators/not-like.md) | Fuzzy matching, negative usage of Like |
| [COALESCE](comparison-functions-and-operators/coalesce.md)|Returns the first non-null value|

## [**Control Flow Function**](flow-control-functions/flow-control-functions-overview.md)

| Name | Description |
|---|----|
| [CASE](flow-control-functions/case-when.md) | Case when operator |
| [IF()](flow-control-functions/function_if.md) | If/else statement |
| [IFNULL()](flow-control-functions/function_ifnull.md) | If null/else statement |
| [NULLIF()](flow-control-functions/function_nullif.md) | NULL is returned when expr1 = expr2, otherwise it returns expr1 |

## [**Logical operator**](logical-operators/logical-operators-overview.md)

| Name | Description |
|---|----|
| [AND,&&](logical-operators/and.md) | Logic and |
| [NOT,!](logical-operators/not.md) | Logical non |
| [OR](logical-operators/or.md) | Logical or |
| [XOR](logical-operators/xor.md) | Logical XOR |