Postgresql - how to find specify string in ANY arrays in the column

Question

I have column array[] named tags.

i have here f.e.:

{{dogs, cats, phones, bottles}}
{{pistols,politican,juices}}
{{dogs,pistols}}
etc..

I want to find in all of them f.e. word "dogs" and select only entries with "dogs". I tried to use:

SELECT * FROM question WHERE tags[0] = ANY(ARRAY['dogs']);

Given your sample data, what exactly is the result you want? — user330315
– user330315, Commented Sep 11, 2018 at 12:47
Have you tried "reversing" the ANY like 'dogs' = ANY (tags[0])? — sticky bit
– sticky bit, Commented Sep 11, 2018 at 12:47

user330315 · Accepted Answer · 2018-09-11 12:44:20Z

4

You need to do it the other way round:

SELECT * 
FROM question 
WHERE 'dogs' = ANY(tags);

The above assumes that tags is a one-dimensional array, e.g. text[]

answered Sep 11, 2018 at 12:44

user330315

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

1 Comment

I love you. In my angry i lost easiest result. Thank you.