We have log/audits we have compiled over some time that we would like to run some brief reports on. One of the columns in the logs is JSON, but contains XML. We want to be able to parse out the value of a certain XML tag for each of the rows. So given an arbitrary string such as the following:\[code\]{ "XmlData" :"<tag1><tag2><TagToParse>234</TagToParse></tag2><tag1>".....}\[/code\]I would like to run a sql query that return 234 when I give it the tag name TagToParseWhat is the easiest way to do this ENTIRELY in SQL?
Parsing XML Element value entirely in SQL form arbitrary string
- Thread starter swampdude
- Start date