[Koha] database help needed

[Chris Cormack]

2010/4/8 Vimal Kumar <vimal0212 at gmail.com>:
> Dear Koustubha, Magnu and Lenora,
>
> Thank you for the quick response.
>
> I understood from your mail that data in 650 stored in xml and we have to
> filter it from there.
>
> This thing also mentioned in SQL Library in Koha Wiki.
>
> According to the SQL Library following query will filter data from 650-a
> field in biblio number 24.
>
> SELECT
>   ExtractValue((SELECT marcxml FROM biblioitems WHERE biblionumber=24),
> '//datafield[@tag="650"]/subfield[@code>="a"]') AS ITEM
>
> What are the changes in query list entire 650-a field from all records?
>

You would need to write a little script to do it, one that selects all
the bibloitems, then extracts value for each one.

If you try to extractvalue on more than one row at a time mysql will complain.

Chris