Select * From users Where (location = 'chicago' or displ...


Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A about the site for music historians, critics, and fans

--who live in your city (hint: there’s a column with their geographic data in it), 
--OR who have your city in their name,
--who have accessed StackOverflow in the last year.

Select * From users
Where (location = 'chicago' or 
displayname like '%chicago%')
and LastAccessDate > Dateadd(year, -1, getdate())

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results