Users Location LIKE '%XXX%' with Website

0

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. Only users with a website will be displayed

Network Engineering

Q&A for network engineers

-- Users Location LIKE '%XXX%' with Website
-- Find users who's location field contains the specified parameter.
-- Only users with a website will be displayed

SELECT us.DisplayName, 
us.Id as [User Link],
  us.Reputation,
  us.WebsiteUrl,
  us.Age,
  
  us.Location
FROM Users us
WHERE Location LIKE '%##Location##%'
and websiteurl like '%http://%.%'
ORDER BY us.Reputation DESC

Enter Parameters

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