© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
13 replies
MrZe0n

Query data in jsonb values array

I have a jsonb type column, and I want to use a filter such as in() or contains() to check if one of the values matches my query. The column has an array ["blue", "green"], so I want to have a function such as in('colours', ["orange", "blue"]) and have it match, is that possible?
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

Array of jsonb .or() not working
SupabaseSSupabase / help-and-questions
4y ago
Are periods supported in key names of JSONB values?
SupabaseSSupabase / help-and-questions
4y ago
Unable to filter on jsonb array column
SupabaseSSupabase / help-and-questions
4y ago
Comparing query data with an array of numbers
SupabaseSSupabase / help-and-questions
4y ago