MySQL Forums
Forum List  »  Connector/Node.js

XPath Problem - can't get the tag name of a node...
Posted by: Petar Petrov
Date: April 14, 2007 08:19AM

hi all,

I'm using the XPath engine of MySQL 5.1 and I have the following XML structure:

<a>
<b>1</b>
<c>2</c>
<d>3</d>
</a>

What I want to extract is the tag name of the first child of <a>, e.g. I want to extract the value "b".
I know I can access the <b> node as follows:
SELECT EXTRACTVALUE(columnName,'/a/child::*[1]') from tableName;
This gives me the fist child's text, e.g. "1", but I can't figure out how to get its tag name.

I would be extremely grateful for any hint you could give!

Regards,
Pesho

Options: ReplyQuote


Subject
Written By
Posted
XPath Problem - can't get the tag name of a node...
April 14, 2007 08:19AM


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.