Skip to content

Instantly share code, notes, and snippets.

@shmaltorhbooks

shmaltorhbooks/replace.sql

Last active December 17, 2015 04:58
Show Gist options
  • Save shmaltorhbooks/5553824 to your computer and use it in GitHub Desktop.
Save shmaltorhbooks/5553824 to your computer and use it in GitHub Desktop.
Download ZIP
find and replace CR
Raw
replace.sql
SELECT * FROM auto4.model WHERE `name` like '%\n';
UPDATE auto3.model m SET name=REPLACE(name, '\n', '')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment