Q&A about the site for members of the workforce navigating the professional setting
select id, displayname, location from users where location like '(^|[[:space:],])((new[[:space:]]*york([[:space:]]*city)?|nyc|manhattan|brooklyn|queens|bronx|staten[[:space:]]island)|(albany|buffalo|rochester|syracuse|yonkers|utica|troy|binghamton|white[[:space:]]plains)|ny|new[[:space:]]york[[:space:]]state))([[:space:],]|$)';