MySQL - CONCAT() function example

In this article, we would like to show you CONCAT() function example in MySQL.

Quick solution:

xxxxxxxxxx

SELECT CONCAT("expression1", "expression2", "expressionN")

AS 'alias_name';

In this example

Query:

xxxxxxxxxx

SELECT CONCAT("Simon", " ", 'Collins', ' ', '987-654-321')

AS 'phone_contact';

Result:

Note:

You can use both single and double quotation marks.

Note:

CONCAT() function can be also used to merge values or search many columns. Go to this article to see more complex examples.

• MySQL - find row with null value in one of many columns