[Koha] Koha - query for biblioitems marc

[Linda]

Galen,
That did the trick!   Thank you!
> Subject:
> Re: [Koha] Koha - query help needed for bilblioitems.marc
> From:
> Galen Charlton <gmc at esilibrary.com>
> Date:
> 8/22/2012 10:27 AM
>
> To:
> koha at 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 at 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