Xpath 1.0 Mysql issue
I have this sample xml <ProductSaleItem> <ItemReference>100</ItemReference> <Discount> <Modifier>1</Modifier> </Discount> </ProductSaleItem> <ProductSaleItem> <ItemReference>101</ItemReference> <Discount> <Modifier>1</Modifier> </Discount> <Discount> <Modifier>2</Modifier> </Discount> </ProductSaleItem> <ProductSaleItem> <ItemReference>102</ItemReference> </ProductSaleItem> and this xpath //ProductSaleItem[Discount/Modifier]/ItemReference i am hoping to get 100 101 but all i get is 100…