enlacee/mysql.replace.sql

Created August 1, 2016 15:01

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/enlacee/ba553bd6af499f6e365c232e1bf4d354.js"></script>
Save enlacee/ba553bd6af499f6e365c232e1bf4d354 to your computer and use it in GitHub Desktop.

Download ZIP

sql replace mysql http://stackoverflow.com/questions/5956993/mysql-string-replace

Raw

mysql.replace.sql

	UPDATE your_table
	SET your_field = REPLACE(your_field, 'articles/updates/', 'articles/news/')
	WHERE your_field LIKE '%articles/updates/%'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment