<?xml version="1.0" encoding="windows-1252"?>
<node id="1011038" title="Re^2: DBI accessing SQLite with XML data" created="2012-12-31 05:34:41" updated="2012-12-31 05:34:41">
<type id="11">
note</type>
<author id="961">
Anonymous Monk</author>
<data>
<field name="doctext">
Actually I found a way using regular expressions. You have to create a custom regexp function and then use it to parse the XML (courtesy of http://www.justatheory.com/computers/databases/sqlite/).
&lt;br&gt;&lt;br&gt;
Not exactly what I was looking for and surely not very efficient performance-wise, but for now it does the trick.
</field>
<field name="root_node">
1011021</field>
<field name="parent_node">
1011024</field>
<field name="reputation">
10</field>
</data>
</node>
