MySQL CONCAT Function: Examples

Back Home

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