Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow Meta en español

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

select id, displayname, location
from users
where lower(REPLACE(location, ' ', '') ) LIKE '%newyork%' or REPLACE(location, ' ', '')  LIKE '%NY%'

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results