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

0

Please login or register to vote for this query.

(click on this box to dismiss)

Arts and Crafts Meta

Q&A about the site for artists and crafters

--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

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