Operators

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