ยฉ 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabaseโ€ข4y agoโ€ข
7 replies
floyare

I can't filter posts by json column

So I have my column with JSON values that look like this:
['admin','user','mod']
['admin','user','mod']
and I want to select rows with these tags in json column named
tags
tags
. I tried to do it by using
.contains('tags', tags)
.contains('tags', tags)
but it's returning to me with error that
"details":"Token \"admin\" is invalid."
"details":"Token \"admin\" is invalid."
Of course
tags
tags
variable is stored as json array. Anybody have an idea?
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

Can't filter by uuid...
SupabaseSSupabase / help-and-questions
4y ago
Query JSON Column
SupabaseSSupabase / help-and-questions
4y ago
Filter using json isnt working
SupabaseSSupabase / help-and-questions
4y ago
How do I filter by multiple options?
SupabaseSSupabase / help-and-questions
4y ago