MySQL JOIN and CONCAT issue with data

Question

I scraped some data from a website, where I wanted the data to look like this:

company_name | location | tags 
----------------------------------
company1     | USA      | tag1, tag2
company2     | China    | tag3, tag4, tag5

But instead the scraper pulled data in this format:

company_name | location | tags 
----------------------------------
company1     | USA      | tag1
company1     | USA      | tag2
company2     | China    | tag3
company2     | China    | tag4
company2     | China    | tag5

How would I turn the current data I have what I want above?

What version do you have? ... you might be able to use GROUP_CONCAT on the tags. — Paul T.
– Paul T., Commented Jul 11, 2020 at 1:27

Gordon Linoff · Accepted Answer · 2020-07-11 01:27:48Z

2

You can use group_concat():

select company_name, location, group_concat(tags separator ', ')
from t
group by company_name, location;

answered Jul 11, 2020 at 1:27

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Comments

The Impaler · Accepted Answer · 2020-07-11 01:27:58Z

1

You can use GROUP_CONCAT(). For example:

select 
  company_name,
  location,
  group_concat(tags) as tags
from t
group by company_name, location

answered Jul 11, 2020 at 1:27

The Impaler

49.3k10 gold badges50 silver badges90 bronze badges

Collectives™ on Stack Overflow

MySQL JOIN and CONCAT issue with data

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related