1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, teachers and students of the Korean language

SELECT Id as [Post Link], Id, CreationDate, Score, ViewCount, LEN(Body) as Size
FROM Posts
WHERE (
   Body LIKE '% teh %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%plz%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%idk%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '% sth%' COLLATE SQL_Latin1_General_Cp1_CI_AS 
OR Body LIKE '% smth%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%wanna %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%gotta%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%dunno%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '% dont %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '% cant %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%doesnt %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR
(  Body LIKE '%wont %' COLLATE SQL_Latin1_General_Cp1_CI_AS
   AND
   Body NOT LIKE '%wont to%' COLLATE SQL_Latin1_General_Cp1_CI_AS
)
OR Body LIKE '%hasnt %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%isnt %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%didnt %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%whats %' COLLATE SQL_Latin1_General_Cp1_CI_AS

OR Body LIKE '%everytime%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%seperate%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%alot%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%usefull %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%adress %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%deamon%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%succesfully%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%enviroment%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%formated%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '% Ive %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%comand %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%approx %' COLLATE SQL_Latin1_General_Cp1_CI_AS

-- too many false-positives
-- OR Body like '% i %'  
or Body like '% i''m %' or Body like '% i''d %' COLLATE SQL_Latin1_General_CP1_CS_AS
)
AND ClosedDate IS NULL
AND DATEDIFF(DAY, CreationDate, GETDATE()) < ##Age:int?7##
AND Score >= ##Score:int?5##
-- to narrow down a bit more
AND LEN(Body) < 3000
ORDER by CreationDate DESC

fork query

edited jan 9

created nov 19 Jeff Schaller