CONCAT_WS()

Description

This function CONCAT_WS() stands for Concatenate With Separator and is a special form of CONCAT(). The first argument is the separator for the rest of the arguments. The separator is added between the strings to be concatenated. The separator can be a string, as can the rest of the arguments. If the separator is NULL, the result is NULL.

Syntax

  • Syntax 1
  1. > CONCAT_WS(separator,str1,str2,...)
  • Syntax 2
  1. > CONCAT_WS(separator,str1,NULL,str1,...);

Arguments

ArgumentsDescription
strRequired. both CHAR and VARCHAR are supported.

Examples

  1. SELECT CONCAT_WS(',','First name','Second name','Last Name');
  2. +--------------------------------------------------+
  3. | concat_ws(,, First name, Second name, Last Name) |
  4. +--------------------------------------------------+
  5. | First name,Second name,Last Name                 |
  6. +--------------------------------------------------+
  7. 1 row in set (0.01 sec)
  8. > SELECT CONCAT_WS(',','First name',NULL,'Last Name');
  9. +-------------------------------------------+
  10. | concat_ws(,, First name, null, Last Name) |
  11. +-------------------------------------------+
  12. | First name,Last Name                      |
  13. +-------------------------------------------+
  14. 1 row in set (0.01 sec)