MySQL操作XML格式字段

参考：https://blog.csdn.net/hejiajunhs/article/details/84487945

-- Example #E1
SELECT extractValue ( 'Googlewww.google.com', '/sites/site/name' ) AS VALUE;


-- Example #E2
SELECT extractValue ( 'Googlewww.google.com', '/*/*/name' ) AS VALUE;


-- Example #E3
SELECT extractValue ( 'Googlewww.google.com', '/sites/site/child::*' ) AS VALUE;
SELECT extractValue ( 'Googlewww.google.com', '/descendant::*' ) AS VALUE;
SELECT extractValue ( 'Googlewww.google.com', '/sites/site/parent::*' ) AS VALUE;
SELECT extractValue ( 'Googlewww.google.com', '/sites/site/name/ancestor::*' ) AS VALUE;
SELECT extractValue ( 'Googlewww.google.com', '/sites/site/url/self::*' ) AS VALUE;


-- Example #E4
SELECT extractValue ( 'JMelton', '/book/author/surname[self:text()>="Melton"]' ) AS VALUE;


-- Example #U1
SELECT UpdateXML ( 'Googlewww.google.com', '/sites/site/name', 'GG' ) AS VALUE


-- Example #U2
SELECT extractvalue ( UpdateXML ( 'Googlewww.google.com', '/sites/site/name', 'GG' ), '/sites/site/name' ) AS value;