Find users by location

5

Please login or register to vote for this query.

(click on this box to dismiss)

Shows all the users for the supplied location parameter, sorted by reputation. The Location parameter is an SQL wild card. For example: %Africa%

Ukrainian Language Meta

Q&A about the site for linguists, teachers and students of the Ukrainian language

-- Find users by location
-- Shows all the users for the supplied location parameter, sorted by reputation.  The parameter is a wild card.
SELECT TOP(100)
  u.Id,
  u.DisplayName,
  u.Reputation,
  u.WebsiteUrl,
  u.Age,
  u.LastAccessDate,
  u.Location
FROM Users u
WHERE u.Location LIKE ##Location:string##
ORDER by u.Reputation DESC

Enter Parameters

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