Member Avatar for riyapethe

my table structre like this
ID nAME
1 Mumbai,Pune,Chennai

i want output of name like this
Name
Mumbai

Pune

Chennai

pl help
m 'new to sql

Thanks in Advance

  • 3 Contributors
  • 2 Replies
  • 67 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by crishjeny
Member Avatar for debasisdas

post your code here, i will fix it.

Member Avatar for crishjeny

split your Name values with "," and then use as per your needs

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.