CONCAT_WS

Combine multiple expressions, inserting a “-” separator between each of them.

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

Definition and Usage

The CONCAT_WS() function merges two or more expressions with a specified separator, and it’s worth considering the CONCAT() function as well.

CONCAT_WS(separator, expression1, expression2, expression3,…)

Parameter	Description
separator	Necessary: The separator to be inserted between each expression. If the separator is NULL, the function returns NULL.
expression1, expression2, expression3, etc.	Necessary: The expressions to be combined. Any expression with a NULL value will be excluded.

Works in:

From MySQL 4.0

Combine data from three columns into a single “Address” column, separated by spaces.

SELECT CONCAT_WS(” “, Address, PostalCode, City) AS Address
FROM Customers;