MySQL Forums
Forum List  »  Connector/Node.js

Extracting the only one element from xml
Posted by: Dhruba Mahanta
Date: September 25, 2007 03:17AM

I used the following statements,
INSERT INTO x VALUES
('
<book>
<title>A guide to the SQL standard</title>
<author>
<initial>Dhruba</initial>
<surname>Mahanta</surname>
</author>
</book>
');

and

INSERT INTO x VALUES
('
<book>
<title>A guide to the SQL standard</title>
<author>
<initial>Debojit</initial>
<surname>Saikia</surname>
</author>
</book>
');
Now how can I display only 'Dhruba' and 'Mahanta' by using mysql statements from what I have entered in database. Please help.

Options: ReplyQuote


Subject
Written By
Posted
Extracting the only one element from xml
September 25, 2007 03:17AM


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.