0

Please login or register to vote for this query.

(click on this box to dismiss)

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'

view current version

edited jun 15 12

created jun 15 12 Daniel Beck