Using multiple filters on one update request

[HaMM4R]

Hi all,

I'm new to using supabase and REST API's as a whole and just wondered if there was a way to perform multiple .eq filters on one update request? I'm building a leaderboard in Godot and it needs to modify values based on two rows being the same rather than one. Any help would be much appreciated :)

[inian]

Hey @HaMM4R,

Yup you can chain multiple .eq filters in the same query. Here is an example.

[HaMM4R]

Hi inian, thanks for the quick response, it must just be the Godot plugin for supabase that I'm using doesn't support it yet.

[saltcod]

Hey guys! Curious about the syntax for multiple fields — I want to filter years. Is it ..select().eq('year', '2017').eq('year', '2018').eq('year', '2019'). or is there some kind of array syntax there?
thanks!

[steve-chavez]

@saltcod An in filter(.in('year', ['2017', '2018', '2019'])) would be fit there.

[saltcod]

Missed this reply — THANK YOU! Amazing!