Skip to content

Instantly share code, notes, and snippets.

@bartubozkurt

bartubozkurt/text_operators_2.sql

Created June 11, 2021 17:46
Show Gist options
  • Save bartubozkurt/41f12b4ed7009ff85833158662265447 to your computer and use it in GitHub Desktop.
Save bartubozkurt/41f12b4ed7009ff85833158662265447 to your computer and use it in GitHub Desktop.
Download ZIP
Fetch names of cities that start with any letter followed by 'ublin' (like Dublin in Ireland or Lublin in Poland)
Raw
text_operators_2.sql
SELECT name
FROM city
WHERE name LIKE '_ublin';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment