How to get data that contains a specific dynamic value?

I am trying to get data based on search input using .contains but I get an error.

const { data, error } = await supabase.from("Event").select().contains('name', searchValue );


I tried .ilike and it works but only if I search for the entire name, which is not what I am looking for, not some part of it e.g the first 3 letters
Was this page helpful?