eq()

Match only rows where column is equal to value.

To check if the value of column is NULL, you should use .is() instead.

1const { data, error } = await supabase
2  .from('countries')
3  .select()
4  .eq('name', 'Albania')

Parameters#

  • columnrequired
    ColumnName

    The column to filter on

  • valuerequired
    object

    The value to filter with

Examples#

With select()#

1create table
2  countries (id int8 primary key, name text);
3
4insert into
5  countries (id, name)
6values
7  (1, 'Afghanistan'),
8  (2, 'Albania'),
9  (3, 'Algeria');