Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Hey there, a quick question. Is there a way for chaining `ilike` when querying a table? In my case I have a text field of pipe-separated categories and I would like to look for all the rows that contain one or multiple categories, so I'd need to use multiple `ilike`s

As an example, two categories could be Card management|Area Control and Area Control|Deck Building|  and I would like to search for %Area Control% or %Deck Building$

I don't see why it shouldn't be possible with multiple ilikes:
https://supabase.com/docs/reference/javascript/ilike

Are you getting an error?

Seems like I was getting an error from the formatting of the string. I just checked and it works no problem!