This article explains the MySQL string functions which are used to concatenate two or more strings. 1. CONCAT : CONCAT() function is used to generate a string by concatenating two or more strings. The ...

The full form of CONCAT_WS is concatenate with Separator which is a special form of CONCAT(). The first argument in CONCAT_WS is used as a separator for concatenate all other arguments. The separator ...

GROUP_CONCAT, LISTAGG or some other name, depending on the SQL dialect, is an aggregation function which takes values from several rows and lists them in a single string, separated by some pre-defined ...