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%');

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?

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