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? — , Sep 11 '18 at 12:47
Have you tried "reversing" the `ANY` like `'dogs' = ANY (tags[0])`? — sticky bit, Sep 11 '18 at 12:47

score 4 · Accepted Answer · answered Sep 11 '18 at 12:44

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 '18 at 12:44

I love you. In my angry i lost easiest result. Thank you. – Kamil Sep 11 '18 at 12:51

1 Answers1