[Koha] 942 c searching and generating reports

[Chris Cormack]

On 15 December 2011 14:39, Elaine Bradtke <eb at efdss.org> wrote:
> Nope, that didn't work.  How about something that will give me the
> biblio number and the contents of the associated 942$c?
> I can sort those in a spreadsheet and it might also give me a clue as
> to what's going on.
> Elaine

What didn't work about it? You got no results? or not the right amount?

SELECT biblionumber, ExtractValue(marcxml,
'//datafield[@tag="942"]/subfield[@code="c"]') AS comp FROM
biblioitems

Will give you biblionumber and the contents of 942c .. again only if
your mysql server its 5.1.5 or greater

Chris