How to use where in for multiple items?

SQL++
1

Hello,

Let’s say I have the following document

{
  "tags": [
    "tag2",
    "tag3"
  ]
}

Is it possible to use where in query to select this document?

I’ve tried select * from bucket where ['tag2', 'tag3'] in tags , but it did not work.

Are there any ways to search a document with an array by multiple items?

2

select * from mybucket where ANY t in tags SATISFIES t IN [‘tag2’, ‘tag3’] END;

select * from mybucket where EVERY t in tags SATISFIES t IN [‘tag2’, ‘tag3’] END;

1 Like