[Koha] Koha - query help needed for bilblioitems.marc

[Galen Charlton]

Hi Linda,

On 08/22/2012 10:51 AM, Linda wrote:
> I need to find records having a 773 field that  are missing either a
> subfield "9". or a subfield "o"..
> I'm at a loss of how to accomplish this.   Any input would be appreciated.
> Thanks in advance.

This should do the trick:

SELECT biblionumber
FROM biblioitems
WHERE marcxml RLIKE '<datafield tag="773"'
AND ExtractValue(marcxml, '//datafield[@tag="773"]/subfield[@code="9" or 
@code = "o"]/text()') = '';

Regards,

Galen
-- 
Galen Charlton
Director of Support and Implementation
Equinox Software, Inc. / The Open Source Experts
email:  gmc at esilibrary.com
direct: +1 770-709-5581
cell:   +1 404-984-4366
skype:  gmcharlt
web:    http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org & 
http://evergreen-ils.org