MySQL Forums
Forum List  »  Newbie

xml inside a database
Posted by: asd 123
Date: April 20, 2012 08:34AM

Hello,

I have a huge some xml files of same format. Each of them are stores in a blob cloumn inside a table.


Is there any way that I can query on all xml files together such that the result would be the xml files which fufllfils my query

for e.g.

Table

Primary key ----------file_name -----------------filedata(blob)
1 ---------------------output1 ---------------------blob(file)
2 ---------------------output2 ---------------------blob(file)
3 ---------------------output3 ---------------------blob(file)




If I want to search for the xml files which consist of string "John" inside a node called employee.


A bit more complex query would be to return the salary of the employee by name "John".

Then I should get the first two rows as a result.



thanks,
Srikanth



Edited 2 time(s). Last edit at 04/20/2012 08:43AM by asd 123.

Options: ReplyQuote


Subject
Written By
Posted
xml inside a database
April 20, 2012 08:34AM


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.