On 15 December 2011 14:39, Elaine Bradtke <[email protected]> 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 _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
