CONCAT_
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