In this article, we would like to show you
CONCAT() function example in MySQL.
SELECT CONCAT("expression1", "expression2", "expressionN") AS 'alias_name';
In this example
SELECT CONCAT("Simon", " ", 'Collins', ' ', '987-654-321') AS 'phone_contact';
You can use both single and double quotation marks.
CONCAT()function can be also used to merge values or search many columns. Go to this article to see more complex examples.