MySQL Forums
Forum List  »  Connector/Node.js

XML text in columns
Posted by: Steve Terpening
Date: November 01, 2005 07:59PM

I don't know why I can't find any references to this anywhere, but...
I've got text columns in InnoDB tables that have XML inside them. I need to query these columns, looking for particular elements inside other elements. Any ideas on how to do this quickly in a single SELECT (read avoid a whole table scan)?

The String functions and tips in the manual don't seem to be much help - maybe some new ones are in order:
e.g. ELEMENT(name,str,n): returns the substr in [str] from "<[name]" thru
"/[name]>", where the element is the [n]th occurrence of that element. Maybe add some attribute value checks, etc.

- Steve

PS: If this belongs in the InnoDB forum, please let me know.

Options: ReplyQuote

Written By
XML text in columns
November 01, 2005 07:59PM
January 27, 2006 02:03PM

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.