SELECT TOP 5 id, displayname, location FROM users WHERE (...

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

SELECT TOP 5
    id,
    displayname,
    location
FROM
    users
WHERE
    (LOWER(location) LIKE '%new york%' OR
    LOWER(location) LIKE '%ny%' OR
    LOWER(location) LIKE '%nyc%' OR
    LOWER(location) LIKE '%new york city%') OR
    
    (UPPER(location) LIKE '%new york%' OR
    UPPER(location) LIKE '%ny%' OR
    UPPER(location) LIKE '%nyc%' OR
    UPPER(location) LIKE '%new york city%'
    );

Enter Parameters

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