Q&A for Joomla! administrators, users, developers and designers
SELECT Text, PostId, SUBSTRING( Text, CHARINDEX( 'http://superuser.com/questions/', Text ) + LEN('http://superuser.com/questions/'), CHARINDEX( '/', Text, CHARINDEX( 'http://superuser.com/questions/', Text ) ) + LEN('http://superuser.com/questions/') ) FROM PostHistory WHERE UserId = -1 AND CHARINDEX('<!-- End of automatically inserted text -->', Text) = 0 AND Comment = 'insert duplicate link'