Galen,
That did the trick! Thank you!
Subject:
Re: [Koha] Koha - query help needed for bilblioitems.marc
From:
Galen Charlton <g...@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 lcul...@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
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
