CONCAT_WS()
CONCAT_WS()
It is used to Concatenate With Separator.
The first argument is the separator for the rest of the arguments. The separator is added between the strings to be concatenated. If the separator is NULL, the result is NULL.
Syntax:
CONCAT_WS(separator,str1,str2,…)
Example:
SELECT CONCAT_WS(’-',16,1,2007)
Output:
16-1-2007
