List of Users in a given location. Case Sensitive
Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure
-- List of Users in a given location -- Case Sensitive select Id as [User Link], location, reputation from users where location like '%##location##' -- exclusions and not ( Location LIKE '%IRAN%' --OR Location LIKE '%IRAQ%' --OR Location LIKE '%EIRE%' --OR Location LIKE '%IRC%' OR Location LIKE '%IRI%' OR Location LIKE '%IRS%' OR Location LIKE '%IZMIR%' or Location LIKE '%NAIROBI%' or Location LIKE '%SIRACUSA%' or Location LIKE '%THIRUVANANTHAPURAM%' or Location LIKE '%VIRAMGAM%' or Location LIKE '%YORKSHIRE%' ) order by location asc -- to pick out incorrect results