Operators

ClickHouse operators in Propel

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