How to query text column that is ilike one or more array items?

e.g.,
select * from profiles where name ilike in ('%jim%','%dave%', '%mary%');

Of course, this query doesn't work, but that's I'm trying to do with Supabase client. Any ideas?
Was this page helpful?