Subject: Re: Escaping % sign in a query
did you try this?
On Wed, Jan 11, 2017 at 11:18 AM, Roy Teeuwen <roy@xxxxxxxxxx> wrote:
> Hey all,
> I am trying to do a query where the actual word I am looking for looks
> like %%myword%%. I have tried the following in XPATH and JCR_SQL2, but it
> seems that the % sign is in both query languages a wildcard, meaning i will
> find all the nodes containing myword instead of %%myword%%. How can I
> escape the % sign in either XPATH or JCR_SQL2?
> SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/myfolder])
> and CONTAINS(s.*, '%%myword%%')
> /jcr:root/myfolder//*[jcr:contains(., '%%myword%%')]