JavaScript: Column is a value

Match only rows where column IS value.

For non-boolean columns, this is only relevant for checking if the value of column is NULL by setting value to null.

For boolean columns, you can also set value to true or false and it will behave the same way as .eq().

Parameters

• column

  (Required)

  The column to filter on

• value

  (Required)

  The value to filter with

Examples

Checking for nullness, true or false

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