JavaScript: 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.

Parameters

• column

  (Required)

• operator

  (Required)

• value

  (Required)

Examples

With `select()`

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