[OPEN-ILS-GENERAL] SQL help with MARC LDR

[Tim Spindler]

Mary,

I've used the following where statement to get at for instance one of the
codes in the biblio.record_entry table.

WHERE b.marc ~* '.*<leader>.{6}m.*</leader>.*'

Tim

On Fri, Mar 16, 2012 at 2:27 PM, Mary Llewellyn <mllewell at biblio.org> wrote:

> **
>
> Hi all,
>
> Does anyone know how to write a SQL query to specify a particular Elvl
> value (character position 17) in the MARC LDR to retrieve a list of bibs
> with that value? To be clearer, I’d like to get a list of bibs that have
> Elvl “3”.
>
> I know how to retrieve records from the metabib,real_full_rec table based
> on a tag, but not how to specify a particular byte in the LDR.
>
> Thanks,
>
> Mary
>
> Mary Llewellyn
>
> Database Manager
>
> Bibliomation, Inc.
>
> Middlebury, CT
>
> mllewell at biblio.org
>
>


-- 
Tim Spindler
tjspindler at gmail.com

*P**   Go Green - **Save a tree! Please don't print this e-mail unless it's
really necessary.*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20120316/7b758677/attachment.htm>