clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591703 fiddles created (45706 in the last week).

create table product_variants (product_id int, options_xml xml); insert into product_variants values (132, '<options><option_id>1</option_id><option_id>8</option_id></options>');
1 rows affected
 hidden batch(es)


select p.product_id, t.option_id from product_variants p cross join xmltable('/options/option_id' passing p.options_xml columns option_id integer path '.') as t
product_id option_id
132 1
132 8
 hidden batch(es)