CONCAT

Concatenates the strings listed in the arguments without a separator.

Syntax

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

—OR—

<expression> || <expression2> || [ ...n]

Parameter	Description	Supported input types
`<expression>[, ...n]`	The string(s) to be concatenated.	`TEXT`

NULL inputs to the CONCAT function are treated as empty strings and ignored. When all inputs are NULL, the result will be an empty string.

When using ||, any NULL input results in a NULL output.

Return Types

TEXT

Example

SELECT
	CONCAT('Hello ', 'World!');

Returns: Hello World!

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

Returns:

' +----------------------------------------+
' | user_info                              |
' +----------------------------------------+
' | steven70: daniellegraham@example.net   | 
' | burchdenise: keith84@example.org       | 
' | stephanie86: zjenkins@example.org      |
' | sabrina21: brianna65@example.org       |
' | kennethpark: williamsdonna@example.com |
' +----------------------------------------+