chevron_left Functions Cookbooks

Counting the number of rows in a table Concatenating multiple rows into one field Finding duplicate values Replacing a string Performing regular expression replace

thumb_up

thumb_down

chat_bubble_outline
0
 auto_stories new 
settings

Concatenating multiple rows into one field in MySQL

Database

chevron_right

MySQL

chevron_right

Cookbooks

chevron_right

Functions Cookbooks

schedule Jul 1, 2022

Last updated

local_offer MySQL

Example

Consider the following table about whether students hold a drivers license:

student_id	full_name	age	has_license
1	Sky Towner	17	0
2	Ben Davis	19	1
3	Travis Apple	18	0
4	Arthur David	16	0
5	Benjamin Town	17	1

The above sample table can be created using the code here.

To concatenate the full_name of all students and return in a single row:


        
        
            
                
                
                    SELECT GROUP_CONCAT(full_name)
FROM drivers_license;
                
            
            +--------------------------------------------------------------+
| GROUP_CONCAT(full_name)                                      |
+--------------------------------------------------------------+
| Sky Towner,Ben Davis,Travis Apple,Arthur David,Benjamin Town |
+--------------------------------------------------------------+

For comparison, if we had not used GROUP_CONCAT(~) the result would look like below:


        
        
            
                
                
                    SELECT full_name FROM drivers_license;
                
            
            +---------------+
| full_name     |
+---------------+
| Sky Towner    |
| Ben Davis     |
| Travis Apple  |
| Arthur David  |
| Benjamin Town |
+---------------+

mail

Join our newsletter for updates on new DS/ML comprehensive guides (spam-free)

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Share on Twitter

Share on Facebook

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!