Galen, That did the trick! Thank you!
Subject: Re: [Koha] Koha - query help needed for bilblioitems.marc From: Galen Charlton <gmc@esilibrary.com> Date: 8/22/2012 10:27 AM
To: koha@lists.katipo.co.nz
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
-- Linda Culberson lculber@mdah.state.ms.us Miss. Dept. of Archives and History Archives& Records Services P.O. Box 571 Jackson, MS 39205-0571 Phone: (601) 576-6873