CONCAT
On this page
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: January 17, 2025