mysql concat

The CONCAT function in MySQL is used to concatenate two or more strings into a single string. It takes two or more string arguments and returns a single string that is the result of concatenating the input strings.

Syntax:

CONCAT(string1, string2, ...)

Example:

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

Output:

HelloWorld

In addition to the CONCAT function, MySQL also provides the CONCAT_WS function which allows you to specify a separator between the input strings.

Syntax:

CONCAT_WS(separator, string1, string2, ...)

Example:

SELECT CONCAT_WS('-', 'John', 'Doe', 'Smith');

Output:

John-Doe-Smith