I'm using AEM 6.2.
Is it possible to update content using a SQL2 query with the Tools, Query, SQL2 tool?
select * from [nt:unstructured] as p where isdescendantnode (p, [/content/]) AND [sling:resourceType] like '/apps/project/component%'
and Update the content to '/apps/project/component2'
Thank you in advance for your help.
Check this tool.
I think this is what you are looking for.