MySQL CONCAT Function

Overview

In this tutorial, we will learn about MySQL CONCAT Function with some examples. We can use this function to concatenate strings. Concatenation is combining strings together into one string.

MySQL CONCAT Function

CONCAT() function concatenates the given arguments into one combined string.

Syntax

The general syntax of the function is as follows:

CONCAT(<arg1> [,<arg2>, …., <argn>])

The concatenation operation works with strings and MySQL will convert any other data types
to string first to perform the concatenation.

Examples

Let’s concatenate two strings into one string.

mysql> SELECT CONCAT(‘Hello’,’World’);

Output
+————————-+
| CONCAT(‘Hello’,’World’) |
+————————-+
| HelloWorld |
+————————-+
1 row in set (0.00 sec)

CONCAT String Function

In the example, we have used the CONCAT() function to combine two strings ‘Hello’ and ‘World’

Let’s concatenate three strings into one string.

mysql> SELECT CONCAT(‘Testing’,’Docs’,’.com’);

+———————————+
| CONCAT(‘Testing’,’Docs’,’.com’) |
+———————————+
| TestingDocs.com |
+———————————+
1 row in set (0.01 sec)

MySQL CONCAT Function

mysql> SELECT CONCAT(‘A’,’quick’,’brown’,’fox’);
+———————————–+
| CONCAT(‘A’,’quick’,’brown’,’fox’) |
+———————————–+
| Aquickbrownfox |
+———————————–+

MySQL CONCAT Function