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%

Linguistics Meta

Q&A about the site for professional linguists and others with an interest in linguistic research and theory

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