Skip to content

Instantly share code, notes, and snippets.

@bartubozkurt
Created June 11, 2021 17:41
Show Gist options
  • Save bartubozkurt/4ba9921c0b10b929663558feb805e851 to your computer and use it in GitHub Desktop.
Save bartubozkurt/4ba9921c0b10b929663558feb805e851 to your computer and use it in GitHub Desktop.
Fetch names of cities that start with a 'P' or end with an 's'
SELECT name
FROM city
WHERE name LIKE 'P%' OR name LIKE '%s';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment