MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Display comma separated value Row wise
Posted by: Rahul Deshpande
Date: January 15, 2009 04:23AM

Hi,

I have a column which is storing values using comma separated. I want to display those values in row wise.
e.g.
Indiv_id = selection
1234 = 10,19,20,35

Output should be:
Indiv_id = selection
1234 = 10
1234 = 19
1234 = 20
1234 = 35

Regards,
RD

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Display comma separated value Row wise
Rahul Deshpande
January 15, 2009 04:23AM
Re: Display comma separated value Row wise
laptop alias
January 15, 2009 05:15AM
Re: Display comma separated value Row wise
Rahul Deshpande
January 15, 2009 06:04AM
Re: Display comma separated value Row wise
Vinod Sugur
January 15, 2009 07:19AM
Re: Display comma separated value Row wise
Jay Alverson
January 15, 2009 08:53AM
Re: Display comma separated value Row wise
Rahul Deshpande
January 15, 2009 09:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.