student_id	fname	lname	day_enrolled	age	username
1	Sky	Towner	2015-12-03	17	stowner1
2	Ben	Davis	2016-04-20	19	bdavis2
3	Travis	Apple	2018-08-14	18	tapple3
4	Arthur	David	2016-04-01	16	adavid4
5	Benjamin	Town	2014-01-01	17	btown5

The above sample table can be created using the code here

Basic usage

To concatenate fname and lname with a space in between:


        
        
            
                
                
                    SELECT CONCAT(fname, ' ', lname)
FROM students;
                
            
            +---------------------------+
| CONCAT(fname, ' ', lname) |
+--------------------------+
| Sky Towner                |
| Ben Davis                 |
| Travis Apple              |
| Arthur David              |
| Benjamin Town             |
+---------------------------+

To provide an alias for the resulting column using AS:


        
        
            
                
                
                    SELECT CONCAT(fname, ' ', lname) AS "Full Name"
FROM students;
                
            
            +---------------+
| Full Name     |
+---------------+
| Sky Towner    |
| Ben Davis     |
| Travis Apple  |
| Arthur David  |
| Benjamin Town |
+---------------+

Numeric argument

Numeric arguments are automatically converted to strings:


        
        
            
                
                
                    SELECT CONCAT(fname, ' is ', age, ' years old.') AS "Sentence"
FROM students;
                
            
            +---------------------------+
| Sentence                  |
+---------------------------+
| Sky is 17 years old.      |
| Ben is 19 years old.      |
| Travis is 18 years old.   |
| Arthur is 16 years old.   |
| Benjamin is 17 years old. |
+---------------------------+

NULL argument

NULL is returned if any argument is NULL:


        
        
            
                
                
                    SELECT CONCAT('Hello', NULL);
                
            
            +-----------------------+
| CONCAT('Hello', NULL) |
+-----------------------+
| NULL                  |
+-----------------------+

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

Official MySQL Documentation

https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_concat

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!