Case-insensitive LIKE search in comments only

1

Please login or register to vote for this query.

(click on this box to dismiss)

Literature

Q&A for scholars and enthusiasts of literature

-- 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 sites:
loading Hold tight while we fetch your results