title: MySQL Select Row from table WHERE value > 0
body: <p>Hey im having trouble constructing this mysql query its stumped me for about a week now im hoping someone has the answer and can help me learn!</p>
  
  <p>my table looks like this:
  <img src="https://i.stack.imgur.com/thwr1.png" alt="my table looks like this "></p>
  
  <p><strong>What I want</strong>
  Im looking to get all of the values out of my table WHERE the username OR email = 'abc123' AND WHERE the values of attack strength defense agility etc... are > 0 </p>
  
  <p>So basically how could I only get rows where the values in my columns are greater than 0 and the values are associated with the correct username and email</p>
  
  <p>any help would be much appreciated! im not sure if i explained this the best way but id love to help clarify! </p>
  
  <p>here's what i was working with so far </p>
  
  <pre><code>SELECT Attack, Strength, Defense, Magic, Ranged, Prayer, Runecrafting, Dungeoneering, Construction, Constitution, Agility, Herblore, Thieving, Crafting, Slayer, Hunter, Mining, Smithing, Fishing, Cooking, Firemaking, Woodcutting, Farming, Summoning FROM experience WHERE email =  abc123 OR username = abc123
  </code></pre>