.or()

Finds all rows satisfying at least one of the filters.

• JavaScript
• Python

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.

Examples

With select()

• JavaScript
• Python

const { data, error } = await supabase

.from('cities')

.select('name, country_id')

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

User or with and

• JavaScript
• Python

const { data, error } = await supabase

.from('cities')

.select('name, country_id')

.or('id.gt.20,and(name.eq.New Zealand,name.eq.France)')