suppose there is a table
I think you want
group_concat() with the
select id, group_concat(distinct `desc` separator '/') as `desc` from t group by id;
desc is a bad name for a column because it is a SQL keyword (think
order by). It is best to avoid grammatical elements when choosing names.