MySQL - Group by one value and concat other values in one column [duplicate]

Question

I have a database with email and phone columns. One email can have several phones, which results in multiple rows with same email but different phone numbers.

I want to query all emails with it's phones grouped in one single column.

Example

Convert from this

11111  [email protected]
22222  [email protected]  
33333  [email protected]
44444  [email protected]

To this

[email protected]  11111, 22222, 33333, 44444

Thanks!

I suppose you're trying to transform a numeric value to a single string. Try checking out aggregate functions that can work with strings here >> dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html. — lemon
– lemon, Commented Oct 15, 2022 at 15:20

Mureinik · Accepted Answer · 2022-10-15 15:21:22Z

7

group_concat to the rescue:

SELECT   email, GROUP_CONCAT(other ORDER BY other ASC SEPARATOR ', ') 
FROM     mytable
GROUP BY email

answered Oct 15, 2022 at 15:21

Mureinik

316k54 gold badges399 silver badges405 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Roberto Iglesias · Accepted Answer · 2022-10-15 15:35:08Z

1

I found it

select email,GROUP_CONCAT(tel1,',',tel2) as phones from table group by email;

Thanks!

answered Oct 15, 2022 at 15:35

Roberto Iglesias

771 silver badge7 bronze badges

Collectives™ on Stack Overflow

MySQL - Group by one value and concat other values in one column [duplicate]

Example

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Example

2 Answers 2

Comments

Comments

Linked

Related