MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Convert comma separated string to rows
Posted by: Prabhu Ramakrishnan
Date: October 01, 2015 09:03PM

Hi,

Need some help.. In MYSQL, How to split a comma separated string into rows using regular expressions and without creating functions or procedures. The comma separated string length is dynamic. For eg.

String: 23456,16524,84755,98457,06978,05986,73454,34785

Result
------
23456
16524
84755
98457
06978
05986
73454
34785

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


Subject
Written By
Posted
Convert comma separated string to rows
Prabhu Ramakrishnan
October 01, 2015 09:03PM
Re: Convert comma separated string to rows
Peter Brawley
October 01, 2015 10:05PM
Re: Convert comma separated string to rows
Prabhu Ramakrishnan
October 01, 2015 10:35PM


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.