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

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

fork query

created mar 16 11 anonymous