Tutorial Gateway

MySQL Concat_ws string

by

The MySQL Concat_ws stands for concatenate with separator. It is one of the String Function, which is used to combine two or more strings along with separator. In this article, we will show you, How to write a MySQL string concat_ws function with example.

TIP : If any of the argument is Null value, then concat_ws will return the result as NULL.

MySQL Concat_ws String Syntax

The basic syntax of Concat_ws in MySQL is as shown below:

-- MySQL Concat_WS String Syntax 
SELECT CONCAT_WS (Separator, String 1, String 2,.., String N)
FROM Source

MySQL Concat_ws String Example 1

The MySQL Concat_ws String Function returns the combined string using the seperator. The following query will show you the same.

-- MySQL String Concat_ws Example
SELECT CONCAT_WS(',', 'Tutorial', 'Gateway') AS Str1;

SELECT CONCAT_WS(' ', 'Tutorial', 'Gateway') AS Str2;

SELECT CONCAT_WS(' $ ', 'Learn', 'MySQL', 'at', 'Tutorial', 'Gateway') AS Str3;

SELECT CONCAT_WS(' ', 'Learn', 'MySQL', 'at', 'Tutorial', 'Gateway') AS Str4;

As you can see from the below screenshot, it is combining the string using the separator that we specified as the first argument.

MySQL Concat_ws string 1

MySQL Concat_ws String Example 2

In this example, we are going concatenate the FirstName and LastName columns present in the Employe using space separator, and dollar separator. In order to demonstrate this concat_ws string function, We are going to use the employ table data that we shown below

MySQL Concat_ws string 2

Let me show you the query

-- MySQL String Concat_ws Example
USE `mysql tutorial`;
SELECT  First_Name, 
        Last_Name,
	CONCAT_WS(' ', First_Name, Last_Name) AS FullName1,
        CONCAT_WS(' $ ', First_Name, Last_Name) AS FullName2,
	DepartmentName,
        Email
FROM employe;

OUTPUT

MySQL Concat_ws string 3

TIP : This function is same as Concat function. However, it accept extra argument as the string separator

Thank You for Visiting Our Blog