[OPEN-ILS-GENERAL] SQL help needed

[Bill Ott]

On 9/11/12 7:18 PM, Mary Llewellyn wrote:
> I see 2 ways to go: find and export all the bibs involved, delete the 
> obsolete 856s in a third-party MARC editor, then load the bibs back in 
> and replace the bibs in the database. Or, develop some backdoor way to 
> remove the 856s using SQL, just for the one library. It helps that 
> each library has a unique URL, such as 
> http://smalltownct.oneclickdigital.com. Only trouble is I'm not sure 
> how to write a query incorporating a MARC tag and a particular string.

You'll find an example of using regexp_replace here:
http://www.evergreen-ils.org/dokuwiki/doku.php?id=scratchpad:random_magic_spells#how_to_prune_a_tag_under_the_hood

Your trick will be to craft the regular expression to match the 856, and 
presumably sub 9's, you're looking to clean up.

As noted with that link above, use with caution.  You'd be well served 
to test the query ahead of time, either by using a copy of the data, or 
select some records into a temporary table to test and fine tune your query.

Finally, consider the scope of the query.  Mass editing 
biblio.record_entry will create a lot of DB work while all the edits 
fire the laundry list of triggered functions, so you may need to batch 
the updates.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20120911/375bb3b5/attachment-0001.htm>