CODEWITHSUNDEEP
sqlamazon-web-servicesamazon-simpledb
Sohaib
Sohaib

Reputation: 4694

Query a column where column value could be anything in an array

I am using amazons SimpleDB. My question is simple. I have an array say [1,2,3,4]. I need to query my domain in a manner so that if a particular column's value is in this array that row should be selected.

Is this possible or do I have to write multiple query and run a loop?

Upvotes: 1

Views: 53

Answers (1)

Transformer
Transformer

Reputation: 389

Use IN Function

e.g.

SELECT * FROM [Table]  WHERE [COLUMN_NAME] IN ('1','2','3','4')

Upvotes: 2

Related Questions