From: Peter Brawley
Date: May 24 2009 2:17am
Subject: Re: Is it possible to convert column data into rows
List-Archive: http://lists.mysql.com/mysql/217663
Message-Id: <4A18AE40.70309@earthlink.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------030202050800030002050907"

--------------030202050800030002050907
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

>I have a column which contains a list of IDs separated by commas.  How
>can I take the content of this column, and insert it into a temporary
>table so that each ID is on a separate row?  Can this be done using
>SQL?

Can be done in a stored procedure, or (more easily) in an application 
language.

PB

-----

Khai Doan wrote:
> I have a column which contains a list of IDs separated by commas.  How
> can I take the content of this column, and insert it into a temporary
> table so that each ID is on a separate row?  Can this be done using
> SQL?
>
> Thanks!
>
> Khai
>
>   
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com 
> Version: 8.5.339 / Virus Database: 270.12.37/2130 - Release Date: 05/23/09 07:00:00
>
>   

--------------030202050800030002050907--