1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Split field by Comma

Discussion in 'MySQL' started by Gnaniyar, Jan 27, 2009.

  1. Gnaniyar

    Gnaniyar New Member

    Hi all,

    i want to split field by comma. For example,


    20553, 32115, 78546

    i have this field as id. it may contain 4 or 5 or above that. i want to retrive these in different columns by splitting comma.

    i want ouput like this: ( if 3 values = 3 column or 4 values = 4 column)

    primarySkills primarySkills primarySkills

    20553 32115 78546

    Thanks in advance.

    - Gnaniyar Zubair
  2. Bhullarz

    Bhullarz New Member

    I think PHP's explode function can help you in this.

Share This Page