Skip to content

Instantly share code, notes, and snippets.

@richgcook

richgcook/gist:194ec67edcc2fe14f54f216e5cfc8b1f

Created October 31, 2016 23:34
Show Gist options
  • Save richgcook/194ec67edcc2fe14f54f216e5cfc8b1f to your computer and use it in GitHub Desktop.
Save richgcook/194ec67edcc2fe14f54f216e5cfc8b1f to your computer and use it in GitHub Desktop.
Download ZIP
mySQL replace file extension
Raw
gistfile1.txt
UPDATE field_insitu_featured_image
SET data = REPLACE(data, '.gif', '.jpg')
UPDATE _TABLE_NAME_
SET _COLUMN_ = REPLACE(_COLUMN_, '.gif', '.jpg')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment