Skip to main content
Version: v2 RC

not()

Match only rows which doesn't satisfy the filter.

Unlike most filters, opearator and value are used as-is and need to follow PostgREST syntax. You also need to make sure they are properly sanitized.

const { data, error } = await supabase
.from('countries')
.select()
.not('name', 'is', null)

Parameters

  • columnrequiredColumnName

    The column to filter on

  • operatorrequiredFilterOperator

    The operator to be negated to filter with, following PostgREST syntax

  • valuerequiredobject

    The value to filter with, following PostgREST syntax

Examples

With select()

const { data, error } = await supabase
.from('countries')
.select()
.not('name', 'is', null)