© 2026 Hedgehog Software, LLC

More

Communities Docs About Terms Privacy

Supabase•3y ago•

3 replies

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

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