Users Location LIKE '%XXX%'

5

Please login or register to vote for this query.

(click on this box to dismiss)

Find users who's location field contains the specified parameter

Stack Overflow

Q&A for programmers

-- Users Location LIKE '%XXX%'
-- Find users who's location field contains the specified parameter

SELECT us.DisplayName, 
us.Id as [User Link],
  us.Reputation,
  us.WebsiteUrl,
  us.Age,
  us.LastAccessDate,
  us.Location
FROM Users us
WHERE Location LIKE '%##Location##%'
ORDER BY us.Reputation DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results