title: Selecting count(*) while checking for a value in the results
body: <pre><code>SELECT COUNT(*) as Count, IF(sch.HomeTeamID = 34,true,false) AS Hawaii
  FROM schedule sch 
  JOIN schools s ON s.ID = 83 
  WHERE (sch.HomeTeamID = 83 OR sch.AwayTeamID = 83)
  AND sch.SeasonID = 4
  </code></pre>
  
  <p>I'm trying to use count() to simplify my result but also include a field that represents wether any of the results' specific column contained a certain value. Is this possible? I'd basically like a row response with all the info I need. </p>