Javascript Reference v2.0

Don't match the filter

Match only rows which doesn't satisfy the filter.

not() expects you to use the raw PostgREST syntax for the filter values.

1.not('id', 'in', '(5,6,7)')  // Use `()` for `in` filter
2.not('arraycol', 'cs', '{"a","b"}')  // Use `cs` for `contains()`, `{}` for array values
Parameters
    column
    REQUIRED
    string

    The column to filter on

    operator
    REQUIRED
    string

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

    value
    REQUIRED
    any

    The value to filter with, following PostgREST syntax


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