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
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
No Schema Available
_ilike
Retrieve a list of articles whose titles contain the case-insensitive word "lorem":
GraphiQL
Query Variables
Request Headers
No Schema Available
_nilike
Retrieve a list of articles whose titles do not contain the case-insensitive word "ipsum":
GraphiQL
Query Variables
Request Headers
No Schema Available
