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.
From description - no.
One more option is a bulk editor
But, be aware. From documentation: