MySQL Forums
Forum List  »  Connector/Node.js

Re: Indexes on XML tags?
Posted by: mliberov
Date: July 05, 2006 11:04AM

So, for a concrete example, if I have xmlColumn in myTable that stores integer elements like <num>10</num>, will ExtractValue() treat "10" like text? Would something like this work?
select * from myTable
where ExtractValue(xmlColumn, num) = 10



Edited 2 time(s). Last edit at 07/05/2006 11:07AM by mliberov.

Options: ReplyQuote


Subject
Written By
Posted
cjb
April 18, 2006 04:50PM
June 02, 2006 10:57AM
Re: Indexes on XML tags?
July 05, 2006 11:04AM
December 01, 2006 04:03AM


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.