MySQLString FunctionsCONCAT_WS
CONCAT

CONCAT_WSString Functions

SUBSTRING

Concatenates strings with a separator between each.

Syntax

CONCAT_WS(sep, s1, s2, ...)

Example

Enter values below to update the example in real time.

city
state
country
address
customers
SELECT CONCAT_WS(', ', city, state, country) AS address
FROM customers;