midnite81/remove_trailing_question_marks.sql

Last active June 20, 2020 22:56

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/midnite81/5dda7641365e9e2d8039cb0c8cd2088f.js"></script>
Save midnite81/5dda7641365e9e2d8039cb0c8cd2088f to your computer and use it in GitHub Desktop.

Download ZIP

An example of removing trailing question marks in SQL

Raw

remove_trailing_question_marks.sql

	UPDATE http_redirects_new
	SET redirect_url = trim(trailing '?' FROM redirect_url)
	WHERE redirect_url LIKE '%?'

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