MySQL CONCAT_WS() Function

❮ MySQL Functions

Example

Add several expressions together, and add a "-" separator between them:

SELECT CONCAT_WS("-", "SQL", "Tutorial", "is", "fun!") AS ConcatenatedString;

Try it Yourself »

---

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,...)

Resource:https://www.w3schools.com/sql/func_mysql_concat_ws.asp