split the values which sperated by comma

shanthiash · #1 (**permalink**) 09-02-08, 06:11

Hi guys,

i need this great help from ur side. in my table i am having one field ex: adress_emp in this field the data is like (Meena V Burman,12 Madhav Park,Part-II,Ahmedabad-382418) how can i seperate the values individually like i mentioned below

Meena V Burman
12 Madhav Park
Part-II

please help me to find the solution........

r937 · #2 (**permalink**) 09-02-08, 13:29

do you have a programming language available like php or asp?

that is the best way to approach this problem

shanthiash · #3 (**permalink**) 09-04-08, 01:51

no i am not having that. simply using MYsql query i have to do that.

r937 · #4 (**permalink**) 09-04-08, 05:03

Code:

SELECT REPLACE(adress_emp,',',CHAR(13,10))
  FROM ...

Internet Services

Web Development

Digital Marketing

Consumer Tech