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@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