title: SQL COUNT() WHERE multiple values
body: <p>I'll make this post short: I want to count the number of times my row appears in my table where the row is a specific value And another row could be 4 different values. I'll post my "guess" which doesn't work:</p>
  
  <pre><code>SELECT hero_selected, COUNT(hero_type) FROM heroes WHERE hero_type = 'agi' AND hero_selected = 'yt' OR hero_selected = 'yb' OR hero_selected = 'ym' OR hero_selected = 'yf
  </code></pre>
  
  <p><br/></p>
  
  <h2>INFORMATION ABOUT THE TABLE</h2>
  
  <p><strong>TABLE NAME</strong><br/>
  heroes<br/></p>
  
  <p><strong>ROW TO COUNT</strong><br/>
  hero_type<br/></p>
  
  <p><strong>SELECT "hero_type" WHERE</strong><br/>
  Value is 'agi'</p>
  
  <p><strong>ONLY SELECT IT WHERE "hero_selected" IS</strong><br/>
  Either <em>yt</em>, <em>yb</em>, <em>ym</em> or <em>yf</em></p>
  
  <p>If possible I'd also appreciate the full code including an <em>echo</em> of the count amount in php. Thanks A LOT in advance! :)</p>