CONCAT

Concatenates all of the values in its argument list. If any of the arguments is NULL, the result is NULL. When PIPES_AS_CONCAT flag is on, the symbol || can be used as CONCAT as well.

Info

This function is not to be confused with GROUP_CONCAT, which is an aggregate function returning a concatenation of values passed in during aggregation.

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.

Examples

memsql> select concat('1', '2', '3');
+-----------------------+
| concat('1', '2', '3') |
+-----------------------+
| 123                   |
+-----------------------+

memsql> select concat('1', ' ', '2', ' ', '3');
+---------------------------------+
| concat('1', ' ', '2', ' ', '3') |
+---------------------------------+
| 1 2 3                           |
+---------------------------------+

memsql> select concat(first_name, " ", last_name) from BFFs;
+------------------------------------+
| concat(first_name, " ", last_name) |
+------------------------------------+
| Cecelia Cruz                       |
| Ari Floo                           |
| Skylar Rhodes                      |
+------------------------------------+

memsql> set @@sql_mode = PIPES_AS_CONCAT;

memsql> select 'a' || 'b' || 'c';
+-------------------+
| 'a' || 'b' || 'c' |
+-------------------+
| abc               |
+-------------------+

memsql> select first_name || " " || last_name from BFFs;
+--------------------------------+
| first_name || " " || last_name |
+--------------------------------+
| Cecelia Cruz                   |
| Ari Floo                       |
| Skylar Rhodes                  |
+--------------------------------+

memsql> select '1 ' || concat('2 ', '3');
+---------------------------+
| '1 ' || concat('2 ', '3') |
+---------------------------+
| 1 2 3                     |
+---------------------------+

Related Topics

Was this article useful?