This searches through all the latest version of all the pages:
1 2 3 4 5 6 7 8 9 10 | SELECT DISTINCT FROM CONTENT INNER JOIN BODYCONTENT USING(contentid) WHERE prevver IS NULL AND SPACEID IS NOT NULL AND PARENTID IS NOT NULL AND REGEXP_LIKE(BODY, 'internal-webserver\d(\.example\.com)?\\public' , 'i' ); |
No comments :
Post a Comment