0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

SELECT displayname,   location
FROM Users 
WHERE (location LIKE 'Lug%'
OR location LIKE 'Luh%' )
   AND location NOT LIKE 'Lugansk' AND  location NOT LIKE 'Luhansk'
   AND location NOT LIKE 'Lugansk,%' AND  location NOT LIKE 'Luhansk%'

view current version

edited nov 12

created nov 11 mimi