.or()

Finds all rows satisfying at least one of the filters.

• JavaScript

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

• JavaScript

const { data, error } = await supabase

.from('cities')

.select('name, country_id')

.or('id.eq.20,id.eq.30')

Use or with and

• JavaScript

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

• JavaScript

const { data, error } = await supabase

.from('countries')

.select('id, cities(*)')

.or('name.eq.Wellington,name.eq.Paris', { foreignTable: "cities" })