Skip to content

Instantly share code, notes, and snippets.

@erochest

erochest/gist:3782413

Created September 25, 2012 14:52
Show Gist options
  • Save erochest/3782413 to your computer and use it in GitHub Desktop.
Save erochest/3782413 to your computer and use it in GitHub Desktop.
Download ZIP
More SQL that should not exist....
Raw
gistfile1.sql
update omeka_element_texts
set text=concat('POINT(', insert(text, instr(text, '/'), 0, ')'))
where element_id=38 and text not like 'POINT(%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment