[Koha] Report help needed 999$c

I've got something that extracts the biblio numbers from the 999c. Is there any way to ask it to only show the ones that contain multiple 999c? SELECT biblionumber, ExtractValue(marcxml, '//datafield[@tag=999]/subfield[@code=c]') AS comp FROM biblioitems -- Elaine Bradtke Data Wrangler VWML

Re: [Koha] Report help needed 999$c

Elaine Bradtke schreef op ma 05-05-2014 om 22:55 [+0100]: I've got something that extracts the biblio numbers from the 999c. Is there any way to ask it to only show the ones that contain multiple 999c? SELECT biblionumber, ExtractValue(marcxml, '//datafield[@tag=999]/subfield[@code=c]')

Re: [Koha] Report help needed 999$c

Note that it looked like your data also had multiple entries in one 999 $c field, separated with '|'. That's weird, and this won't find that. On the other hand, you can just do WHERE field LIKE %|% to catch those. Yes, that is weird. I'm trying to figure out where it is coming from. In a few