Skip to content

Instantly share code, notes, and snippets.

@rodrigozrusso

rodrigozrusso/get_data_with_leading_trailing_spaces.sql

Created January 11, 2019 12:40
Show Gist options
  • Save rodrigozrusso/266c8185b0f9bba964f52af747c022f8 to your computer and use it in GitHub Desktop.
Save rodrigozrusso/266c8185b0f9bba964f52af747c022f8 to your computer and use it in GitHub Desktop.
Download ZIP
Select data from column with leading and trailing sapces
Raw
get_data_with_leading_trailing_spaces.sql
select url from mytable where substr(url,1,1) = ' ' or substr(url,-1,1) = ' ';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment