<?xml version="1.0" encoding="UTF-8"?>

<rss version="2.0"
 xmlns:blogChannel="http://backend.userland.com/blogChannelModule"
>

<channel>
<title><![CDATA[Koha Croatian user group: MySQL]]></title>
<link>https://saturn.ffzg.hr/koha-cug/index.cgi?action=weblog_display;category=MySQL</link>
<description></description>
<pubDate>Tue, 11 May 2010 21:14:26 -0000</pubDate>
<webMaster>root@saturn.ffzg.hr</webMaster>
<generator>Socialtext Workspace v2.19.0.2</generator>

<item>
<title><![CDATA[MARCXML]]></title>
<link>https://saturn.ffzg.hr/koha-cug/index.cgi?marcxml</link>
<description><![CDATA[<div>Creator: Dobrica Pavlinušić</div><hr/><div>Tags: MySQL, XPATH</div><hr/><div class="wiki">
<p>
Dohvaćanje podataka iz MARCXML zapisa u Kohi zahtjeva MySQL server 5.1 koji se nalazi u backports za debian lenny.</p>
<p>
Primjeri XPATH upita:</p>
<pre>
mysql&gt; SELECT ExtractValue((SELECT marcxml FROM biblioitems WHERE biblionumber=14), '//datafield[@tag=&quot;260&quot;]/subfield[@code&gt;=&quot;b&quot;]') AS ITEM\G
*************************** 1. row ***************************
ITEM: Z. Šešo, 1978.
1 row in set (0.00 sec)
</pre>
</div>
]]></description>
<author>Dobrica Pavlinu&#x161;i&#x107;</author>
<category>MySQL, XPATH</category>
<guid isPermaLink="true">https://saturn.ffzg.hr/koha-cug/index.cgi?marcxml</guid>
<pubDate>Tue, 11 May 2010 21:14:26 -0000</pubDate>
</item>
</channel>
</rss>