List of Users in a given location. Case Sensitive
Q&A about the site for administrators, end users, developers and designers for Craft CMS
-- List of Users in a given location -- Case Sensitive select Id as [User Link], location, reputation from users where location like '%##location##%' --For the abbreviation right side match or location like '%##Abbreviation##' -- exclusions and not ( Location LIKE '%##dummy##%' ) order by location asc -- to pick out incorrect results