Skip to content

Instantly share code, notes, and snippets.

@meau
Created October 28, 2014 15:52
Show Gist options
  • Save meau/4b8bbb79f4f298d4373d to your computer and use it in GitHub Desktop.
Save meau/4b8bbb79f4f298d4373d to your computer and use it in GitHub Desktop.
round-tripping barcodes from EAD to AT
UPDATE ArchDescriptionInstances SET barcode = instanceType WHERE instanceType REGEXP '^[0-9]{14}$';
UPDATE ArchDescriptionInstances SET instanceType = 'Mixed materials' WHERE instanceType REGEXP '^[0-9]{14}$';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment