P is for Practical | |
PerlMonks |
DBI accessing SQLite with XML databy Anonymous Monk |
on Dec 31, 2012 at 08:33 UTC ( [id://1011021]=perlquestion: print w/replies, xml ) | Need Help?? |
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:
Dear Perlmonks, I am querying a sqlite database which contains XML data in a TEXT column using DBI. Here is a sample of the data contained in that column: <element xmlnssi="http://www.w3.org/2001/XMLSchema-instance" xmlnssd="http://www.w3.org/2001/XMLSchema"><items><item><data>some text here</data></item></items></element> Although I can successfully retrieve the content of that column via a SELECT statement and performing some search and replace to get only the content of element/items/item/data, this is unsatisfactory:
I would like to be able to match the content of /element/items/item/data directly against a LIKE expression such as (pseudo-code):
How could I achieve this? What modules would I need? Thanks for your help.
Back to
Seekers of Perl Wisdom
|
|