Finds all rows whose value on the stated column
is found on the specified values
.
is_
and in_
filter methods are suffixed with _
to avoid collisions with reserved keywords.
final data = await supabase
.from('cities')
.select('name, country_id')
.in_('name', ['Rio de Janeiro', 'San Francisco']);
final data = await supabase
.from('cities')
.update(\{ 'name': 'Mordor' \})
.in_('name', ['Rio de Janeiro', 'San Francisco']);
final data = await supabase
.from('cities')
.delete()
.in_('name', ['Rio de Janeiro', 'San Francisco']);
// Only valid if the Stored Procedure returns a table type.
final data = await supabase
.rpc('echo_all_cities')
.in_('name', ['Rio de Janeiro', 'San Francisco']);