Skip to content

Instantly share code, notes, and snippets.

@Guley

Guley/Replace string from column mysql

Created June 14, 2019 07:02
Show Gist options
  • Save Guley/86cd8804211d27a2a0a599e6eeacd0c9 to your computer and use it in GitHub Desktop.
Save Guley/86cd8804211d27a2a0a599e6eeacd0c9 to your computer and use it in GitHub Desktop.
Download ZIP
Replace string from column mysql
Raw
Replace string from column mysql
UPDATE table_name SET column_name = concat('', substring(column_name, 7)) WHERE `column_name` like '%string/%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment