© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•3y ago•
3 replies
spr1ng

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
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

How to Get only those rows whose jsonb[] column contains an object with specific key-value
SupabaseSSupabase / help-and-questions
3y ago
Fetching data that contains a FK relation not working
SupabaseSSupabase / help-and-questions
4y ago
REST URL Filter: Column contains value
SupabaseSSupabase / help-and-questions
3y ago
Get specific data | Lua Code - Roblox Studio
SupabaseSSupabase / help-and-questions
13mo ago