How would I query a JSON array column such as this for text within each of the array values and only return those rows that have them?
["Mr Smith","Ms Wellington","Mr Anderson"]
I've tried these but neither return results when I know they exist:
select * from people where names::jsonb ? 'Mr'; select * from people where names::jsonb @> 'Mr';