I've got a request to replace instances of internal 'http' urls to 'https' inside rich text components.So I'm using a SQL2 query using CONTAINS to find all nodes that have the text "http://%mysite.com" inside the text property SELECT * FROM [nt:unstructured] AS node
WHERE ISDESCENDANTNODE('/content/...