Help with ExtractValue

[Thomas Bhatia]

Hi All,

Need help with ExtractValue please, here's the table:

mysql> describe ofVCard;
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| username | varchar(64) | NO | PRI | NULL | |
| vcard | mediumtext | NO | | NULL | |
+----------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)



Here's the data in vcard column:

<vCard>
<ADR><WORK/><REGION>Dorset</REGION></ADR>
<ADR><HOME/><REGION>London</REGION></ADR>
</vCard>


Problem is I can't do "select (vcard, '//ADR/WORK/REGION') specifically, which returns nothing.

If I do "select extractvalue(vcard, '//ADR/REGION') from ofVCard;" that'll give me results for both home and work.


Is this a bug, feature or just not supposed to work?

Thanks for any replies.
Thomas