Comparing arrays in WHERE clause

SQL++
, , ,
1

Hi there!

I have a document like so under a Books collection:

{
 "id":"123456",
 "title":"My fight with life",
"tags": ["autobiography", "self-help", "motivational"]
}

How to write a query that matches books with multiple tags?
Something like ANY t IN tags SATISIFIES ANY x in ["motivational", "self-help"]

And that should retrieve this example book

2

Actually, I found it - I figured the query right, except I missed adding an END at the end of ANY t IN tags SATISIFIES ANY x in ["motivational", "self-help"] :slight_smile:

3

It should literally be ANY t IN tags SATISIFIES ANY t in ["motivational", "self-help"] END

2 Likes
4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.