Store strings in variables and concatenate them to display them in a single column in MYSQL

For this, use CONCAT_WS() in MySQL. Let us first create a −

mysql> create table DemoTable1433
   -> (
   -> ClientId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
   -> ClientFirstName varchar(20),
   -> ClientLastName varchar(20)
   -> );
Query OK, 0 rows affected (0.58 sec)

Insert some records in the table using insert −

mysql> insert into DemoTable1433(ClientFirstName,ClientLastName) values('David','Miller');
Query OK, 1 row affected (0.14 sec)

Display all records from the table using select −

mysql> select * from DemoTable1433;

This will produce the following output −

+----------+-----------------+----------------+
| ClientId | ClientFirstName | ClientLastName |
+----------+-----------------+----------------+
|        1 | David           | Miller         |
+----------+-----------------+----------------+
1 row in set (0.00 sec)

Following is the query to store strings in variables and concatenate them −

mysql> set @concat_variable:=(select concat_ws('-',ClientFirstName,ClientLastName) from DemoTable1433);
Query OK, 0 rows affected (0.00 sec)

mysql> select @concat_variable;

This will produce the following output −

+------------------+
| @concat_variable |
+------------------+
| David-Miller     |
+------------------+
1 row in set (0.00 sec)

AmitDiwan

Published on 12-Nov-2019 06:38:46

• Related Questions & Answers
• Find duplicate column values in MySQL and display them
• Concatenate the column values with separate text in MySQL and display in a single column
• How to select different values from same column and display them in different columns with MySQL?
• How to upload multiple files and store them in a folder with PHP?
• Select multiple sums with MySQL query and display them in separate columns?
• MySQL query to count the number of 0s and 1s from a table column and display them in two columns?
• Get distinct values and count them in MySQL
• How to get available wifi networks and display them in a list in android
• How to concatenate all values of a single column in MySQL?
• ORDER BY rand() and keep them grouped in MySQL?
• Select multiple columns and display in a single column in MySQL?
• What do you mean MySQL user variables and how can we assign values to them?
• Concatenate date and time from separate columns into a single column in MySQL
• Is it possible to divide records in both ascending and descending order in MySQL and display them alternatively?
• C program to store Student records as Structures and Sort them by Name