title: Remove stopwords from BigQuery?
body: <p>I have a large list of comments from reddit. The strings are split into words, punctuation removed, and quantified to show the most used words on a particular subreddit:</p>
  
  <pre><code>SELECT word, COUNT(*) as num_words
  FROM(FLATTEN((
    SELECT SPLIT(LOWER(REGEXP_REPLACE(body, r'[\.\",*:()\[\]/|\n]', ' ')), ' ') word
    FROM [fh-bigquery:reddit_comments.2017_08]
    WHERE subreddit="The_Donald"
    ), word))
  GROUP EACH BY word
  HAVING num_words &gt;= 1000
  ORDER BY num_words DESC
  </code></pre>
  
  <p>I have a list of stopwords to remove, how would I go about adding that to the code? Thanks :)</p>