Google mentions in a user's comments

0

Please login or register to vote for this query.

(click on this box to dismiss)

easier to read in a spreadsheet via the 'DOWNLOAD CSV' button

Stack Overflow

Q&A for professional and enthusiast programmers

select
  format(creationdate,'yyyy-MM-dd') as [Posted],
  text as [Comment Text],
  'site://posts/comments/'+cast(id as varchar)+'|'+cast(id as varchar) as [Comment ID + Link]
from comments
where 
  userid=##UserID##
  and text like '%google%' collate SQL_Latin1_General_CP1_CI_AS  --case insensitive
order by 
  creationdate desc




--UserID:Enter a numeric User ID:

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results