how to remove separator in group_concat in mysql

Question

In mysql query am using grpup_concat function to concatenate the rows. It resulting the correct values but it is adding separator. for ex: my result for specified column as below.

{10,20}|,{20,30}|,{40,50} // pipe symbol i have added as a separator but it is again adding comma as a separator.

desired result: {10,20}|{20,30}|{40,50}

let me know how to remove the separator. Thanks in advance.

Can you try a : GROUP_CONCAT(split(field, ","), '|')

user8556290
– user8556290

2017-10-05 06:13:21 +00:00
Commented Oct 5, 2017 at 6:13 — user8556290
– user8556290, Commented Oct 5, 2017 at 6:13

sushil · Accepted Answer · 2017-10-05 06:12:03Z

8

Whatever you need as s separator, specify after SEPARATOR keyword just like below:

SELECT GROUP_CONCAT(field_name SEPARATOR '|') FROM table_name

answered Oct 5, 2017 at 6:12

sushil

2,6813 gold badges20 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

how to remove separator in group_concat in mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related