Select rows where jsonb array contains any string in array

Question

This is my SQL so far:

select * from table where table.json_info @> '{"search_tags":["hello", "world"]}'

And this works if the row has BOTH hello and world in the search_tags

I'm wondering if there is a way to include rows that have EITHER hello OR world and of course those that have both.

Thanks to all ahead of time!

select * from table where table.json_info @> '{"search_tags":["hello"]}' or '{"search_tags":[ "world"]}' — Tharif
– Tharif, Commented Aug 1, 2015 at 4:45

julianwyz · Accepted Answer · 2015-08-01 13:11:27Z

1

Thanks to @utility for putting me on the right track here.

This is what I wound up with:

select * from table where table.json_info @> '{"search_tags":["hello"]}' or table.json_info @> '{"search_tags":[ "world"]}'

answered Aug 1, 2015 at 13:11

julianwyz

3,1802 gold badges32 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1