Skip to main content
Version: v2.x

Postgres: Filter Using Text Values

Introduction

The _like, _nlike, _ilike, _nilike, _similar, _nsimilar, _regex, _nregex, _iregex, _niregex operators are used for pattern matching on string/text fields.

For more details on text search operators and Postgres equivalents, refer to the API reference.

_like

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

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available

_ilike

This query will return all users whose name contains the string "john", regardless of case.

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available

_nilike

This query would return all users whose name does not contain the string "John".

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available
Note

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

_similar

Fetch a list of authors whose names begin with A or C:

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available

_nsimilar

Fetch a list of authors whose names do not begin with A or C:

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available
Note

_similar and _nsimilar are case-sensitive.

_regex

Fetch a list of articles whose titles match the regex [ae]met:

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available

_iregex

This query will return all users whose name matches the regular expression /^joh?n$/i, which matches "John" and "Jon".

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available

_nregex

The _nregex operator in this GraphQL query is a negated regular expression filter that matches all users whose names do not start with the letter "J".

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available
Note

_regex is case-sensitive. Use _iregex for case-insensitive search.

Note

regex operators are supported in in v2.0.0 and above