> ## Documentation Index
> Fetch the complete documentation index at: https://www.propeldata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Operators

> ClickHouse operators in Propel

<div />

Propel offers a wide range of operators in ClickHouse SQL. Here's an overview of the key operators:

## Arithmetic Operators

* `+` : Addition
* `-` : Subtraction
* `*` : Multiplication
* `/` : Division
* `%` : Modulo

## Comparison Operators

* `=`, `==` : Equal to
* `!=`, `<>` : Not equal to
* `<` : Less than
* `>` : Greater than
* `<=` : Less than or equal to
* `>=` : Greater than or equal to

## Logical Operators

* `AND` : Logical AND
* `OR` : Logical OR
* `NOT` : Logical NOT

## BETWEEN Operator

* `a BETWEEN b AND c` : Equivalent to `a >= b AND a <= c`
* `a NOT BETWEEN b AND c` : Equivalent to `a < b OR a > c`

## IN Operator

* `a IN (x, y, z)` : Checks if `a` is equal to any value in the list
* `a NOT IN (x, y, z)` : Checks if `a` is not equal to any value in the list

## LIKE Operator

* `a LIKE pattern` : Pattern matching with `%` (any string) and `_` (any single character)
* `a NOT LIKE pattern` : Negation of LIKE

## IS NULL Operator

* `a IS NULL` : Checks if `a` is NULL
* `a IS NOT NULL` : Checks if `a` is not NULL

## Conditional Operator

* `a ? b : c` : If `a` is true, returns `b`, otherwise returns `c`

## Concatenation Operator

* `||` : Concatenates strings