Link Search Menu Expand Document

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 |
' +----------------------------------------+