My SQL: rewriting comma delimited data to a structured table.
I have a table which consists of the headings <b>Category</b> and <b>Subcategories</b><br /> Within the subcategories heading for each category I have a comma separated list of subcategories.<br />

I would like to rewrite the data to a new table so that the comma separated subcategories are in separate rows with the corresponding category in the previous column.

If anyone has any ideas on how to go about this I would be very grateful.

My SQL: rewriting comma delimited data to a structured table.
===

I have a table which consists of the headings <b>Category</b> and <b>Subcategories</b><br /> Within the subcategories heading for each category I have a comma separated list of subcategories.<br />

I would like to rewrite the data to a new table so that the comma separated subcategories are in separate rows with the corresponding category in the previous column.

If anyone has any ideas on how to go about this I would be very grateful.
