CONCAT

Reference material for CONCAT function

Concatenates, i.e. combines, the text representations of all the input parameters without a separator, in the order they are provided.

Syntax

CONCAT( <expression>[, <expression>[, ...n]] );

—OR—

<expression> || <expression>

Parameters

CONCAT function

Parameter	Description	Supported input types
<expression>[, ...n]	The expressions to be concatenated.	Any type

The parameters to the CONCAT function can be of any data type, and will be converted to their text representation before concatenation. NULL parameters to the CONCAT function are treated as empty strings and ignored. If all parameters are NULL, the result will be an empty string.

|| operator

Parameter	Description	Supported input types
<expression>	The expressions to be concatenated.	Any non-array type, but at least one TEXT

To enable string concatenation, one parameter to the || operator must be of type TEXT, while the other parameter may be of any non-array data type. If one parameter to the || operator is NULL, the result will also be the non-null parameter; if both parameters are NULL, the result will be NULL.

The concatenation operator || can also be used for array concatenation.

Return Type

TEXT

Example

The following example concatenates nickname and email from the players table:

SELECT
  CONCAT(nickname, ': ', email) AS user_info
FROM players
ORDER BY playerid
LIMIT 5;

user_info text
steven70: [e-mail]
burchdenise: [e-mail]
stephanie86: [e-mail]
sabrina21: [e-mail]
kennethpark: [e-mail]

Rows: 5Execution time: 14.47ms