How to add two or more strings in MySQL?

A string function called CONCAT() is used to concatenate two or more strings as a single string in MySQL.

Syntax

CONCAT(String1,String2,…,StringN)

Here, the arguments of CONCAT functions are the strings which need to be concatenated as a single string.

Example

mysql> Select CONCAT('Ram','is','a','good','boy') AS Remarks;

+---------------+
| Remarks       |
+---------------+
| Ramisagoodboy |
+---------------+

1 row in set (0.00 sec)

Fendadis John

Published on 19-Feb-2018 14:08:50

• Related Questions & Answers
• In MySQL, how can I combine two or more strings along with a separator?
• Biggest value from two or more fields in MySQL?
• How to concatenate two or more vectors in R?
• How to find the minimum values of two or more fields in MySQL?
• Program to add two binary strings in C++
• C# program to concat two or more Lists
• Which function in MySQL is used to add white spaces between two strings?
• Comparing two strings in MySQL?
• How to concat two or more columns with separator in Android sqlite?
• How to find the intersection between two or more lists in R?
• How can we combine the values of two or more columns of MySQL table?
• How to find the longest common substring from more than two strings in Python?
• How to check similarity between two strings in MySQL?
• How to use spread operator to join two or more arrays in JavaScript?
• Can I insert two or more rows in a MySQL table at once?