.or()

Finds all rows satisfying at least one of the filters.

const { data, error } = await supabase
.from('cities')
.select('name, country_id')
.or('id.eq.20,id.eq.30')

Parameters

  • filtersrequiredstring

    The filters to use, separated by commas.

  • __namedParametersrequiredobject

    No description provided.

      Properties
    • foreignTablerequiredundefined | string

      The foreign table to use (if column is a foreign column).

Examples

With select()

const { data, error } = await supabase
.from('cities')
.select('name, country_id')
.or('id.eq.20,id.eq.30')

Use or with and

const { data, error } = await supabase
.from('cities')
.select('name, country_id')
.or('id.gt.20,and(name.eq.New Zealand,name.eq.France)')

Use or on foreign tables

const { data, error } = await supabase
.from('countries')
.select('id, cities(*)')
.or('name.eq.Wellington,name.eq.Paris', { foreignTable: "cities" })