Example
SELECT CONCAT_WS("-", "SQL", "Tutorial", "is", "fun!") AS ConcatenatedString;Definition and Usage
The CONCAT_WS() function adds two or more expressions together with a separator.
Note
Also look at the CONCAT() function.
Syntax
CONCAT_WS(
separator
,
expression1
,
expression2
,
expression3
,...)Parameter Values
| Parameter | Description |
|---|---|
| separator | Required. The separator to add between each of the expressions. If separator is NULL, this function returns NULL |
| expression1, expression2, expression3, etc. | Required. The expressions to add together. An expression with a NULL value will be skipped |
Technical Details
| Works in: | From MySQL 4.0 |
|---|