Re: How to select an XML attribut with SQL

[Jonathan Stephens]

Hi!

XPath denotes attributes with the '@' sign, like this:

mysql> SELECT ExtractValue('<tag attr="attrval">nodeval</tag>', '//tag/@attr');
+------------------------------------------------------------------+
| ExtractValue('<tag attr="attrval">nodeval</tag>', '//tag/@attr') |
+------------------------------------------------------------------+
| attrval                                                          |
+------------------------------------------------------------------+
1 row in set (0.00 sec)

Note that XPath considers an attribute to be a child of the element to which it belongs.

Also note that the result in this example is actually a nodeset.

cheers

jon.

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle