xpath of Self-closing XML tag using mysql ExtractValue

Question

Is there any way to know whether the self-closing(<privacy />) XML tag exist inside the xml, using the mysql ExtractValue xpath function.

The xml is,

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<employees>
    <employee>
        <privacy />
        <firstName>Brian</firstName>
        <lastName>Schultz</lastName>
    </employee>
</employees>

SP is

CREATE DEFINER=`root`@`%` PROCEDURE `xpath1`(IN xml VARCHAR(10000))
BEGIN
SELECT  ExtractValue(xml, '//employee/firstName/text()');
/*SELECT  ExtractValue(xml, '//employee/privacy');
 SELECT  ExtractValue(xml, '//employee/privacy/text()');*/
END

ExtractValue(xml, '//employee/privacy'); & ExtractValue(xml, '//employee/privacy/text()'); always return empty space in the result with or without the self-closing tag.

The xml is coming from external app. Any help is great..

I suppose "SELECT ExtractValue(xml, '//employee/privacy/test()')" is a type? Probably you meant: "SELECT ExtractValue(xml, '//employee/privacy/text()')", to see if it contains text()? — Siebe Jongebloed
– Siebe Jongebloed, Commented May 20, 2021 at 12:16

Siebe Jongebloed · Accepted Answer · 2021-05-20 12:15:56Z

2

According to the 8.0 docs you could use count like this:

SELECT  ExtractValue(xml, 'count(//employee/privacy)'

answered May 20, 2021 at 12:15

Siebe Jongebloed

4,9252 gold badges17 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

xpath of Self-closing XML tag using mysql ExtractValue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related