bartubozkurt/text_operators.sql

Created June 11, 2021 17:41

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

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

Download ZIP

Fetch names of cities that start with a 'P' or end with an 's'

Raw

text_operators.sql

	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