Javascript Reference v1.0

Column is a value

A check for exact equality (null, true, false), finds all rows whose value on the stated column exactly match the specified value.

Parameters
    column
    REQUIRED
    object

    The column to filter on.

    value
    REQUIRED
    boolean | null

    The value to filter with.


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