Is it possible to convert column data into rows

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Is it possible to convert column data into rows

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