JanitorText: Upvoted posts containing lower-case "i" (1862)


Please login or register to vote for this query.

(click on this box to dismiss)

Unix and Linux

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

select Id as [Post Link], Body, Score, CreationDate from Posts where  
ParentId is null and
ClosedDate is NULL and
Score > 1 and
(Body like '% i %' or Body like '% i''m %' or Body like '% i''d %' COLLATE SQL_Latin1_General_CP1_CS_AS)
ORDER BY CreationDate DESC

Enter Parameters

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