like '...'

like '...'

Allows for substring searches in text strings

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 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 City of Chicago Salaries for “chiefs” (be careful to URL encode your % characters as %25, something most HTTP clients will help you to do):

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