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.

Q&A about the site for administrators, end users, developers and designers for Craft CMS

-- 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.Age,
  
  us.Location
FROM Users us
WHERE Location LIKE '%##Location##%'
ORDER BY us.Reputation DESC

fork query

edited apr 23 12

created dec 14 11 oid