ExtractValue in mysql is not working for me -
i have xml string
set @xml='<?xml version="1.0" encoding="utf-8" standalone="yes"?> <seatest xsi:schemalocation="https://sea.retain.hawcik.com/schema /seatestschema https://sea.retain.hawcik.com/schema/seatestschema1.0.xsd" xmlns="https://sea.retain.hawcik.com/schema/seatestschema" xmlns:xsi="http://www.w9.org/2999/xmlschema-instaccc"> <worksourcets> <testworksourcets> <worksourcetsname>site01</worksourcetsname> <sourcetsdetails> <duringssunits> <duringssunit> <duname>test.net</duname> <sourcetsstatus>req</sourcetsstatus> <completetestastext>test.com,site01,11/10/2014</completetestastext> <mentionedduedate></mentionedduedate> <mentionedpriority>normal</mentionedpriority> <duspecificaddtionlyelementtes> <elementte> <elementtename>requesteddate</elementtename> <elementtedatatype>date</elementtedatatype> <elementtevalue>11/10/2014</elementtevalue> </elementte> </duspecificaddtionlyelementtes> </duringssunit> </duringssunits> </sourcetsdetails> </testworksourcets> </worksourcets> </seatest>'; select extractvalue(@xml, '//duname');
here want value duname tag test.net. don't know why i'm getting null. please let me know if wrong in above query.
Comments
Post a Comment