Case-insensitive LIKE search in comments only

1

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

-- Like: LIKE argument "Google 'docs transact sql like' for syntax"
-- MaxCount: Max records "Limit the number of returned records"
select top(##MaxCount:int?500##) id [Comment Link], [text]
  from comments
  where [text] collate SQL_Latin1_General_CP1_CI_AS
     like '##Like?%readprotected%##%' collate SQL_Latin1_General_CP1_CI_AS
  order by score desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results