SQL Query to gather all comments containing college names from /r/ApplyingToCollege

grabColleges.txt

SELECT
  body, created_utc, score, author

FROM [fh-bigquery:reddit_comments.all]

WHERE subreddit = "ApplyingToCollege"
AND (LOWER(body) LIKE LOWER("% Princeton University %")
OR LOWER(body) LIKE LOWER("% princeton %")
OR LOWER(body) LIKE LOWER("% Harvard University %")
OR LOWER(body) LIKE LOWER("% harvard %")
OR LOWER(body) LIKE LOWER("% University of Chicago %")
OR LOWER(body) LIKE LOWER("% uchicago %")
OR LOWER(body) LIKE LOWER("% uc hicago %")
OR LOWER(body) LIKE LOWER("% Yale University %")
OR LOWER(body) LIKE LOWER("% yale %")
OR LOWER(body) LIKE LOWER("% Columbia University %")
OR LOWER(body) LIKE LOWER("% columbia %")
OR LOWER(body) LIKE LOWER("% Massachusetts Institute of Technology %")
OR LOWER(body) LIKE LOWER("% mit %")
OR LOWER(body) LIKE LOWER("% m.i.t %")
OR LOWER(body) LIKE LOWER("% Stanford University %")
OR LOWER(body) LIKE LOWER("% stanford %")
OR LOWER(body) LIKE LOWER("% University of Pennsylvania %")
OR LOWER(body) LIKE LOWER("% upenn %")
OR LOWER(body) LIKE LOWER("% wharton %")
OR LOWER(body) LIKE LOWER("% u penn %")
OR LOWER(body) LIKE LOWER("% Duke University %")
OR LOWER(body) LIKE LOWER("% duke %")
OR LOWER(body) LIKE LOWER("% California Institute of Technology %")
OR LOWER(body) LIKE LOWER("% caltech %")
OR LOWER(body) LIKE LOWER("% Dartmouth College %")
OR LOWER(body) LIKE LOWER("% dartmouth %")
OR LOWER(body) LIKE LOWER("% Johns Hopkins University %")
OR LOWER(body) LIKE LOWER("% john hopkins %")
OR LOWER(body) LIKE LOWER("% jhu %")
OR LOWER(body) LIKE LOWER("% johns hopkins %")
OR LOWER(body) LIKE LOWER("% Northwestern University %")
OR LOWER(body) LIKE LOWER("% northwestern %")
OR LOWER(body) LIKE LOWER("% Brown University %")
OR LOWER(body) LIKE LOWER("% brown %")
OR LOWER(body) LIKE LOWER("% Cornell University %")
OR LOWER(body) LIKE LOWER("% cornell %")
OR LOWER(body) LIKE LOWER("% Rice University %")
OR LOWER(body) LIKE LOWER("% rice %")
OR LOWER(body) LIKE LOWER("% Vanderbilt University %")
OR LOWER(body) LIKE LOWER("% vanderbilt %")
OR LOWER(body) LIKE LOWER("% University of Notre Dame %")
OR LOWER(body) LIKE LOWER("% notre dame %")
OR LOWER(body) LIKE LOWER("% Washington University in St. Louis %")
OR LOWER(body) LIKE LOWER("% wustl %")
OR LOWER(body) LIKE LOWER("% w.u.s.t.l %")
OR LOWER(body) LIKE LOWER("% Georgetown University %")
OR LOWER(body) LIKE LOWER("% georgetown %")
OR LOWER(body) LIKE LOWER("% Emory University %")
OR LOWER(body) LIKE LOWER("% emory %")
OR LOWER(body) LIKE LOWER("% University of California--Berkeley %")
OR LOWER(body) LIKE LOWER("% uc berkeley %")
OR LOWER(body) LIKE LOWER("% berkeley %")
OR LOWER(body) LIKE LOWER("% ucb %")
OR LOWER(body) LIKE LOWER("% University of California--Los Angeles %")
OR LOWER(body) LIKE LOWER("% ucla %")
OR LOWER(body) LIKE LOWER("% University of Southern California %")
OR LOWER(body) LIKE LOWER("% usc %")
OR LOWER(body) LIKE LOWER("% Carnegie Mellon University %")
OR LOWER(body) LIKE LOWER("% cmu %")
OR LOWER(body) LIKE LOWER("% carnegie mellon %")
OR LOWER(body) LIKE LOWER("% carnegie melon %")
OR LOWER(body) LIKE LOWER("% University of Virginia %")
OR LOWER(body) LIKE LOWER("% uva %")
OR LOWER(body) LIKE LOWER("% u.v.a %")
OR LOWER(body) LIKE LOWER("% Wake Forest University %")
OR LOWER(body) LIKE LOWER("% wake forest %")
OR LOWER(body) LIKE LOWER("% Tufts University %")
OR LOWER(body) LIKE LOWER("% tufts %")
OR LOWER(body) LIKE LOWER("% New York University %")
OR LOWER(body) LIKE LOWER("% nyu %")
OR LOWER(body) LIKE LOWER("% n.y.u %")
OR LOWER(body) LIKE LOWER("% University of North Carolina--Chapel Hill %")
OR LOWER(body) LIKE LOWER("% unc chapel hill %")
OR LOWER(body) LIKE LOWER("% chapel hill %")
OR LOWER(body) LIKE LOWER("% uncch %")
OR LOWER(body) LIKE LOWER("% Boston College %")
OR LOWER(body) LIKE LOWER("% bc %")
OR LOWER(body) LIKE LOWER("% College of William and Mary %")
OR LOWER(body) LIKE LOWER("% william and mary %")
OR LOWER(body) LIKE LOWER("% william & mary %")
OR LOWER(body) LIKE LOWER("% w and m %")
OR LOWER(body) LIKE LOWER("% w&m %")
OR LOWER(body) LIKE LOWER("% w & m %")
OR LOWER(body) LIKE LOWER("% Brandeis University %")
OR LOWER(body) LIKE LOWER("% brandeis %")
OR LOWER(body) LIKE LOWER("% Georgia Institute of Technology %")
OR LOWER(body) LIKE LOWER("% gatech %")
OR LOWER(body) LIKE LOWER("% gtech %")
OR LOWER(body) LIKE LOWER("% georgia tech %")
OR LOWER(body) LIKE LOWER("% ga tech %")
OR LOWER(body) LIKE LOWER("% University of Rochester %")
OR LOWER(body) LIKE LOWER("% rochester %")
OR LOWER(body) LIKE LOWER("% Boston University %")
OR LOWER(body) LIKE LOWER("% bu %")
OR LOWER(body) LIKE LOWER("% Case Western Reserve University %")
OR LOWER(body) LIKE LOWER("% case western %")
OR LOWER(body) LIKE LOWER("% cwru %")
OR LOWER(body) LIKE LOWER("% University of California--Santa Barbara %")
OR LOWER(body) LIKE LOWER("% ucsb %")
OR LOWER(body) LIKE LOWER("% u.c.s.b %")
OR LOWER(body) LIKE LOWER("% uc santa barbara %")
OR LOWER(body) LIKE LOWER("% Northeastern University %")
OR LOWER(body) LIKE LOWER("% northeastern %")
OR LOWER(body) LIKE LOWER("% Tulane University %")
OR LOWER(body) LIKE LOWER("% tulane %")
OR LOWER(body) LIKE LOWER("% Rensselaer Polytechnic Institute %")
OR LOWER(body) LIKE LOWER("% rpi %")
OR LOWER(body) LIKE LOWER("% rensselaer %")
OR LOWER(body) LIKE LOWER("% r.p.i %")
OR LOWER(body) LIKE LOWER("% University of California--Irvine %")
OR LOWER(body) LIKE LOWER("% uc irvine %")
OR LOWER(body) LIKE LOWER("% irvine %")
OR LOWER(body) LIKE LOWER("% ucirvine %")
OR LOWER(body) LIKE LOWER("% uci %")
OR LOWER(body) LIKE LOWER("% University of California--San Diego %")
OR LOWER(body) LIKE LOWER("% ucsd %")
OR LOWER(body) LIKE LOWER("% uc san diego %")
OR LOWER(body) LIKE LOWER("% University of Florida %")
OR LOWER(body) LIKE LOWER("% u of f %")
OR LOWER(body) LIKE LOWER("% uoff %")
OR LOWER(body) LIKE LOWER("% Lehigh University %")
OR LOWER(body) LIKE LOWER("% lehigh %")
OR LOWER(body) LIKE LOWER("% Pepperdine University %")
OR LOWER(body) LIKE LOWER("% pepperdine %")
OR LOWER(body) LIKE LOWER("% University of California--Davis %")
OR LOWER(body) LIKE LOWER("% ucd %")
OR LOWER(body) LIKE LOWER("% uc davis %")
OR LOWER(body) LIKE LOWER("% davis %")
OR LOWER(body) LIKE LOWER("% University of Miami %")
OR LOWER(body) LIKE LOWER("% miami %")
OR LOWER(body) LIKE LOWER("% University of Wisconsin--Madison %")
OR LOWER(body) LIKE LOWER("% uw madison %")
OR LOWER(body) LIKE LOWER("% uwmadison %")
OR LOWER(body) LIKE LOWER("% university of wisconsin %")
OR LOWER(body) LIKE LOWER("% University of Michigan--Ann Arbor %")
OR LOWER(body) LIKE LOWER("% umich %")
OR LOWER(body) LIKE LOWER("% university of michigan %")
OR LOWER(body) LIKE LOWER("% u mich %"))