not like '...'

not like '...'

Allows for matching text fields that do not contain a substring

Works with the following datatypes:

This function works with 2.1 endpoint(s). What does this mean? »

The like '...' function allows you to filter for Text values that do not match a given pattern. Patterns can include placeholders to make fuzzy matches:

  • An underscore (_) matches a single character
  • A percent symbol (%) matches any string of zero or more characters

For example, to query the employees at the City of Chicago who aren’t advisors (the ‘%’ characters are URL encoded as ‘%25’):

https://data.cityofchicago.org/resource/tt4n-kn4t.json?$where=job_titles not like '%2525ADVISOR%2525'