Q&A for administrators and users of the CiviCRM Constituent Relationship Management software
SELECT u.Id AS [User Link], CONCAT('https://superuser.com/users/', u.Id) AS [Profile Link], u.DisplayName, u.Location, u.WebsiteUrl, u.AboutMe, u.Views, u.UpVotes, u.DownVotes FROM Users u WHERE LOWER(Location) LIKE '%stuttgart%'