Rude posts

1

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

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 to meta site
loading Hold tight while we fetch your results