Care needs to be taken
SELECT * FROM nt:base WHERE jcr:path LIKE '/userenv/%'
works, but
SELECT * FROM nt:base WHERE jcr:path LIKE '/userenv%'
does not.
Care needs to be taken
SELECT * FROM nt:base WHERE jcr:path LIKE '/userenv/%'
works, but
SELECT * FROM nt:base WHERE jcr:path LIKE '/userenv%'
does not.
Why does the second query not work?
No idea :), remember is a JSR-170 SQL query, not a RDBMS SQL query.