MySQL CONCAT Function: Examples

Examples
Sample Database

#1

SELECT 'MySQL ' 'String ' 'Concatenation';

#2

SELECT CONCAT('MySQL','CONCAT');

#3

SELECT CONCAT('MySQL',NULL,'CONCAT');

#4

SELECT 
    concat(contactFirstName,' ',contactLastName) Fullname
FROM
    customers;

#5

SELECT CONCAT_WS(',','John','Doe');

#6

SELECT CONCAT_WS(NULL ,'Jonathan', 'Smith');

#7

SELECT CONCAT_WS(',','Jonathan', 'Smith',NULL);

#8

 SELECT 
    CONCAT_WS(CHAR(13),
            CONCAT_WS(' ', contactLastname, contactFirstname),
            addressLine1,
            addressLine2,
            CONCAT_WS(' ', postalCode, city),
            country,
            CONCAT_WS(CHAR(13), '')) AS Customer_Address
FROM
    customers;

Table List

customers

SELECT * FROM customers;

employees

SELECT * FROM employees;

offices

SELECT * FROM offices;

orderdetails

SELECT * FROM orderdetails;

orders

SELECT * FROM orders;

payments

SELECT * FROM payments;

productlines

SELECT * FROM productlines;

products

SELECT * FROM products;

Result