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 u.displayname,   u.location
FROM Users u
WHERE (u.location LIKE 'Lug%' OR u.location LIKE 'Luh%' )
   AND location NOT LIKE 'Lugansk,%' AND  location  NOT LIKE 'Luhansk,%'    -- город в начале, продолжается адрес
   AND location NOT LIKE '%, Lugansk' AND location NOT LIKE '%, Luhansk'          -- город в конце, после адреса
   AND location NOT LIKE 'Lugansk' AND  location  NOT LIKE 'Luhansk'

fork query

edited nov 12

created nov 11 mimi