MySQL Forums
Forum List  »  Connector/Node.js

Help with ExtractValue
Posted by: Thomas Bhatia
Date: January 18, 2009 10:54AM

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

Options: ReplyQuote


Subject
Written By
Posted
Help with ExtractValue
January 18, 2009 10:54AM
January 18, 2009 03:37PM
February 18, 2009 02:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.