PostgreSQL Select WHERE column = [Array]

Question

I have a table1 with column 1 and 2

1        2
Banana   x
Apple    y
Orange   z

I want to call a SELECT on this table with an array as parameter: ['Banana', 'Apple']

I want to get the rows where column 1 contains Banana or Apple (elements of the array)

SELECT * FROM table1 WHERE column1 = 'Banana OR column1 = 'Apple'

But how is this working dynamically? Like where column1 = elemt in array....?

user330315 · Accepted Answer · 2020-03-12 14:55:11Z

2

Use the ANY operator:

select *
from the_table
where the_column = any( array['Banana', 'Apple'] );

answered Mar 12, 2020 at 14:55

user330315

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

Comments

dounyy · Accepted Answer · 2020-03-12 15:16:06Z

1

Use the keyword IN:

SELECT * FROM table1 WHERE column1 IN ('Banana', 'Apple');

user330315

answered Mar 12, 2020 at 14:56

dounyy

66513 silver badges26 bronze badges