MySQL Forums
Forum List  »  Connector/Node.js

sorting on xml property
Posted by: stgma stgma
Date: November 18, 2005 12:22PM

Hello

I'm really new to stored procedures in general and I would like to ask if this is possible in MySQL 5.0

I have this table with some fields (id, title, parent etc..) and a text field which contains a simple XML document of this form:
<person>
<age>5</age>
<name>john</name>
<surname>smith</surname>
</person>

Is it possible to have a stored procedure extract a fieldname (lets say 'name') from the xml doc and generate a field on my table so I can do ORDER BY 'name' ?

For extraction I would search for '<name>' and '</name>' and return the string inbetween, but I just dont know if I can generate a virtual row to do the job.

Thanks!

Options: ReplyQuote


Subject
Written By
Posted
sorting on xml property
November 18, 2005 12:22PM
November 19, 2005 01:32AM


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.