Queries against document keys

SQL++
1

Hello Masters,

Is it possible to run N1QL queries against document ids (keys).
For example I’d like to retrieve all the keys that own specific prefix.

Thanks in advance,
Erwin

2

Hello Erwin,

Yes. For example, you can run the following in the tutorial:

SELECT META().id, * FROM tutorial WHERE META().id LIKE “da%”