Q&A about the site for administrators, end users, developers and designers for Craft CMS
Select * From Users Where Upper(Location) Like '%' + Upper('##LocationOr1##') + '%' OR Upper(Location) Like '%' + Upper('##LocationOr2##') + '%' OR Upper(Location) Like '%' + Upper('##LocationOr3##') + '%' OR Upper(Location) Like '%' + Upper('##LocationOr4##') + '%' Order by CreationDate Desc