Skip to main content
Version: v2.x

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
Request Headers
Documentation Explorer
No Schema Available
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
Request Headers
Documentation Explorer
No Schema Available

_ilike​

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

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available

_nilike​

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

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available
Loading...