achmadhadikurnia/query_to_string_replace.sql

Created April 4, 2023 02:42

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

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

Download ZIP

Raw

query_to_string_replace.sql

	UPDATE table
	SET field = REPLACE(field, 'replace string', 'replace to')
	WHERE field LIKE '%replace string%'

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