Important
The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.
In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.
CONCAT
On this page
The CONCAT() function concatenates all of the values in its argument list.
If any of the arguments is NULL, the result is NULL.PIPES_ flag is on, the symbol || can be used as CONCAT as well.
Note
This function is not to be confused with GROUP_
Syntax
CONCAT(expression, [ expression, [expression ...]])expression || expression || expression ... || expression
Arguments
-
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.
Remarks
-
The symbol
||can take two different roles.If the sql_session variable is set asmode PIPES_, thenAS_ CONCAT ||is an alias for the CONCAT function else, it is an alias for logicalOR. -
The value of the
sql_variable is checked each timemode ||symbol is encountered.The role of the symbol changes accordingly. -
When used as concatenation operator,
||symbol has a higher precedence than the logicalOR.
Examples
SELECT CONCAT('1', '2', '3');
+-----------------------+
| CONCAT('1', '2', '3') |
+-----------------------+
| 123 |
+-----------------------+SELECT CONCAT('1', ' ', '2', ' ', '3');
+---------------------------------+
| CONCAT('1', ' ', '2', ' ', '3') |
+---------------------------------+
| 1 2 3 |
+---------------------------------+SELECT CONCAT(first_name, " ", last_name) FROM bffs;
+------------------------------------+
| CONCAT(first_name, " ", last_name) |
+------------------------------------+
| Cecelia Cruz |
| Ari Floo |
| Skylar Rhodes |
+------------------------------------+Using pipes (||) for concatenation:
SET @@sql_mode = PIPES_AS_CONCAT;SELECT 'a' || 'b' || 'c';
+-------------------+
| 'a' || 'b' || 'c' |
+-------------------+
| abc |
+-------------------+SELECT first_name || " " || last_name FROM bffs;
+--------------------------------+
| first_name || " " || last_name |
+--------------------------------+
| Cecelia Cruz |
| Ari Floo |
| Skylar Rhodes |
+--------------------------------+SELECT '1 ' || CONCAT('2 ', '3');
+---------------------------+
| '1 ' || CONCAT('2 ', '3') |
+---------------------------+
| 1 2 3 |
+---------------------------+Related Topics
Last modified: