Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2008
    Posts
    2

    Unanswered: split the values which sperated by comma

    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........

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    do you have a programming language available like php or asp?

    that is the best way to approach this problem
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Sep 2008
    Posts
    2
    no i am not having that. simply using MYsql query i have to do that.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Code:
    SELECT REPLACE(adress_emp,',',CHAR(13,10))
      FROM ...
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •