Skip to main content
Version: v2 RC

is()

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().

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

Parameters

  • columnrequiredColumnName

    The column to filter on

  • valuerequiredobject

    The value to filter with

Examples

Checking nullness

Using the eq() filter doesn't work when filtering for null:

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

Instead, you need to use is():

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