0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for enthusiasts and scholars of mythology and folklore

SELECT
	id,
	displayname,
	location 
FROM
	users 
WHERE
	( location LIKE '%New York%' ) 
	OR ( location LIKE '%NY%' ) 
	OR ( location LIKE '%NYC%' ) 
	OR ( location LIKE '%New York city%' ) 
	OR ( location LIKE '%new york%' ) 
	OR ( location LIKE '%nyc%' ) 
	OR ( location LIKE '%new york city%' )
	OR ( location LIKE '%ew%' AND location LIKE '%ork%' );

fork query

edited sep 20

created sep 19 anonymous