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