CONCAT

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

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

One parameter to the || operator must be of type TEXT, while the other parameter may be of any non-array data type. Array types are not supported to avoid ambiguity with the array concatenation operator. If necessary, explicit type casts can be used to circumvent this restriction. If any parameter to the || operator is NULL, the result will also be NULL.

Return Type

TEXT

Example

The following example concatenates users’ nicknames and emails from the players table:

SELECT
	CONCAT(nickname, ': ', email) as user_info
FROM players
LIMIT 5;

Returns: