Check If Record Exists

[cdt-eth]

I have a watchlist table with an id column.

I want to check if the movie page im on's id matches an id in said table column. When I'm on a movie page I have access to the specific id. I've looked in the docs for .is(), .contains(), .match(), .eq() and I'm not sure which is best for this.

I'm looking for a boolean value to be returned.

[burggraf]

You can simply use .eq() and check for the length of the result.

 const { data, error} = await supabase
    .from('watchlist')
    .select()
    .eq('id', the_id_variable_I_want_to_check);
if (data?.length > 0) console.log('it exists') else console.log('nope')

[cdt-eth]

thanks!