BigQuery: Filter Using Text Values

Introdution

The _like, _nlike, _ilike, _nilike operators are used for pattern matching on string/text fields.

_like

Fetch a list of articles whose titles contain the word “amet”:

GraphiQL

Query Variables

Note

_like is case-sensitive. Use _ilike for case-insensitive search.

_nlike

Retrieve a list of articles whose titles do not contain the word "Lorem":

GraphiQL

Query Variables

_ilike

Retrieve a list of articles whose titles contain the case-insensitive word "lorem":

GraphiQL

Query Variables

_nilike

Retrieve a list of articles whose titles do not contain the case-insensitive word "ipsum":

GraphiQL

Query Variables