All Products
Document Center

Concatenation operator

Last Updated: Jan 04, 2020

The || operator can also be used as a logical OR operator. The two semantics are controlled by SQL MODE.

  • If SQL MODE contains PIPES_AS_CONCAT, || is an operator for character concatenation.
  • If SQL MODE does not contain PIPES_AS_CONCAT, || is a logical OR operator.
Operator Operand Description
|| Binary Concatenates two strings.