Filter array attribute in jsonb column type using jsonb_array_elements_text
You can use the contains all ?&amp; operator with arrays:

select * 
from r_fav 
where favorites -&gt; 'favoriteColors' ?| array['Blue', 'Red']


That will return rows at least one of the colors exist in the array. If want those where all colors are contained, use the operator ?&amp; instead