CONCAT_ WS
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
CONCAT_
stands for concatenation with separator.
The first argument is a separator that is placed in between the remaining arguments when concatenating them together.
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
Last modified: February 27, 2023