How to select specific data in array

SQL++
1

Here is a simple document

Bucket : BOOK    
doc id: book01
    {
    "title": "adventure",
    "custom": [
    	{"tag": "a01","price": 99},
    	{"tag": "b01","price": 99},
    	{"tag": "c01","price": 99}
    	]
    }

How to use N1QL to select the data, {“tag”: “b01”,“price”: 99} ?

The only thing I can do is to
SELECT custom[1] FROM BOOK WHERE title=‘adventure’

But the order maybe random and the tag value is not in pattern.

1 Like