0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited sep 8 16 Jeff Schaller

created may 24 10 sam.saffron