How to use Group_Concat() to concat in MySql

Question

I have table structure like this-

 Code         Codelang          Name

  14           de              David
  14           en              Michel
  14           es              John

I want to show this table as-

 Code                Name

 14               [:de]David[:en]Michel[:es]John[:]

Is it possible to do this using Group_Concat() or is there any other way to do this.?

This is, at best, a very strange task to ask of the database. Perhaps it's a manipulation that you should perform in the presentation layer of your application (i.e. in the program code that accesses MySQL)? — eggyal
– eggyal, Commented Mar 4, 2015 at 17:37

Alex · Accepted Answer · 2015-03-04 18:06:37Z

1

SELECT
  code,
  GROUP_CONCAT(CONCAT('[:',codelang,']',name) SEPARATOR '') as name
FROM table1
GROUP BY code

to get [:] at the end you can try:

SELECT
  code,
  CONCAT(GROUP_CONCAT(CONCAT('[:',codelang,']',name) SEPARATOR ''),'[:]') as name
FROM table1
GROUP BY code

edited Mar 4, 2015 at 18:06

answered Mar 4, 2015 at 17:48

Alex

17.3k1 gold badge31 silver badges52 bronze badges

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

4 Comments

shashank Over a year ago

hello thanks Alex for reply. using your code I am getting this- [:de]David[:en]Michel[:es]John it is missing [:] at the end.

shashank Over a year ago

What will be the mysql query if I want to copy this column data to another column.? I have got follwing structure after applying above query. Code Nombre 14 [:de]David[:en]Michel[:es]John[:]

Alex Over a year ago

I don't understand... why do you need data to be copied using sql?

shashank Over a year ago

Hey Alex Please check- stackoverflow.com/questions/28862294/…

Collectives™ on Stack Overflow

How to use Group_Concat() to concat in MySql

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related