CONCAT
Concatenates the strings listed in the arguments without a separator.
Syntax
CONCAT( <string>[, ...n] );
—OR—
<string> || <string2> || [ ...n]
| Parameter | Description |
<string>, <string2>[, ...n] | The strings to be concatenated. |
Example
SELECT
concat('Hello ', 'World!');
Returns: Hello World!