Link to home
Start Free TrialLog in
Avatar of devmasters
devmasters

asked on

How to concatenate strings as single row which actually results in multiple row MySQL?

I  don't know how to address this problem. But all i need is concatenate strings as single row which actually results in multiple row in mysql table.

I hope the below attachments will give clear idea about what i am looking for?
scripts.sql
tableresult.png
ASKER CERTIFIED SOLUTION
Avatar of Wim_Bl
Wim_Bl
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
little  fix for Wim_Bl solution

SELECT NAME, GROUP_CONCAT(Description SEPARATOR ', ')
    FROM Products GROUP BY NAME;
Avatar of devmasters
devmasters

ASKER

Thanks Wim_Bl