EN
MySQL - CONCAT() function example
0
points
In this article, we would like to show you CONCAT() function example in MySQL.
Quick solution:
SELECT CONCAT("expression1", "expression2", "expressionN")
AS 'alias_name';
Practical example
In this example
Query:
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.