Concat_ws

Description

Syntax

VARCHAR concat ws (VARCHAR sep., VARCHAR str,...)

Using the first parameter SEP as a connector, the second parameter and all subsequent parameters are spliced into a string. If the separator is NULL, return NULL. The concat_ws function does not skip empty strings, but NULL values.

example

1. mysql> select concat_ws("or", "d", "is");
2. +----------------------------+
3. | concat_ws('or', 'd', 'is') |
4. +----------------------------+
5. | doris                      |
6. +----------------------------+

8. mysql> select concat_ws(NULL, "d", "is");
9. +----------------------------+
10. | concat_ws(NULL, 'd', 'is') |
11. +----------------------------+
12. | NULL                       |
13. +----------------------------+

15. mysql> select concat_ws("or", "d", NULL,"is");
16. +---------------------------------+
17. | concat_ws("or", "d", NULL,"is") |
18. +---------------------------------+
19. | doris                           |
20. +---------------------------------+

keyword

CONCAT_WS,CONCAT,WS