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
objectThe column to filter on.
value
REQUIRED
boolean | nullThe value to filter with.
const { data, error } = await supabase
.from('cities')
.select('name, country_id')
.is('name', null)