Users located in Kansas or Missouri or Arkansas

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select displayName, Reputation, WebsiteUrl, Location, AboutMe from Users 
where upper(Location) like '%KANSAS%'
OR upper(Location) like '% KS'
OR upper(Location) like '% KS %' 
OR upper(Location) = 'KS' 
union
select displayName, Reputation, WebsiteUrl, Location, AboutMe from Users 
where upper(Location) like '%MISSOURI%' 
OR upper(Location) like '% MO'
OR upper(Location) like '% MO %' 
OR upper(Location) = 'MO' 
union
select displayName, Reputation, WebsiteUrl, Location, AboutMe from Users 
where upper(Location) like '%ARKANSAS%' 
OR upper(Location) like '% AR'
OR upper(Location) like '% AR %' 
OR upper(Location) = 'AR' 
order by Reputation desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results