Subject: Escaping % sign in a query
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