Rude posts

1

Please login or register to vote for this query.

(click on this box to dismiss)

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

SELECT TOP 500
  bad_word, id AS [Post Link]
FROM (
  SELECT 
    id, body,
    CASE
      WHEN LOWER(body) LIKE '%fuck%'     THEN 'fuck'
      WHEN LOWER(body) LIKE '%idiot%'    THEN 'idiot'
      WHEN LOWER(body) LIKE '%moron%'    THEN 'moron'
      WHEN LOWER(body) LIKE '%nigger%'   THEN 'nigger'
      WHEN LOWER(body) LIKE '%pussy%'    THEN 'pussy'
      WHEN LOWER(body) LIKE '%retard%'   THEN 'retard'
      WHEN LOWER(body) LIKE '%shut up%'  THEN 'shut up'
    END AS bad_word
  FROM posts
) t
WHERE bad_word IS NOT NULL
ORDER BY LEN(body) ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results