I have a table, called product_variants, with one integer column and one xml column containing a set of foreign key values.
If I ran,
select product_id, options_xml from product_variants
This would be a typical result
product_id | options_xml 132 | <options><option_id>1</option_id><option_id>8</option_id></options>
I would like to somehow select a new row for each option_id.
The result I want,
product_id | option_id 132 | 1 132 | 8
Thank you in advance!