XML queries XPATH/XQUERY thar returns -


i'm building library database, want query when i'm looking subject. structure of xml database

<!-- language: lang-xml --> <?xml version="1.0" encoding="utf-8"?> <ebook-database title="engineering">   <ebook title="eb-001">    <reference>eb-001</reference>    <title>power installations</title>    <level1>introduction   </level1>   <level1>power utilities     <level2>power cables</level2>     <level2>power lines</level2>   </level1>   <level1>high voltage installations     <level2>cable structure</level2>   </level1>  </ebook>  </ebook-database> 

i want make xpath/xquery search string "cable", return me "cable" mentioned in chapter(level 1) "power utilities" , "high voltage installations" of ebook "eb-001".

thanks in advance,

semir

use translate function make search case insensitive

//*[contains(translate(text(), 'cable', 'cable') ,'cable')] 

result

element='<level2>power cables</level2>' element='<level2>cable structure</level2>' 

Comments