Outdated Version

You are viewing an older version of this section. View current production version.

CONCAT_WS

CONCAT_WS stands for concatenation with separator. The first argument is a separator that is placed in between the remaining arguments when concatenating them together. If any of the expressions is NULL it is skipped in the concatenated output.

Syntax

CONCAT_WS(separator, expression, [ expression, [expression ...]])

Arguments

  • separator: A separator expression. This may be a column name, the result of another function, or a math operation.
  • expression: any set of expressions. This may be a column name, the result of another function, or a math operation.

Return Type

The concatenated string.

Examples

select concat_ws('a','1','2','3');
+----------------------------+
| concat_ws('a','1','2','3') |
+----------------------------+
| 1a2a3                      |
+----------------------------+

select concat_ws('a','1',NULL,'3');
+-----------------------------+
| concat_ws('a','1',NULL,'3') |
+-----------------------------+
| 1a3                         |
+-----------------------------+

Related Topics