title: How to find records from MySQL where only part of fields meet the conditions?
body: <p>I'm a MySQL rookie and I'm stuck on the following problem.
  I have a table and there're 3 numeric value fields in it. I call them A, B, and C.
  I want to find records where there're at least two values > 60.
  One way to solve the problem is</p>
  
  <pre><code>SELEC * FROM table WHERE (A&gt;60 AND B&gt;60) OR (A&gt;60 AND C&gt;60) OR (B&gt;60 AND C&gt;60) OR (A&gt;60 AND B&gt;60 AND C&gt;60)
  </code></pre>
  
  <p>But I don't think this is an elegant way. There is only 3 values. If there are 10 or 20 value fields in the table, and I also want to find records where there're at least two values > 60. Using the above way to solve the problem would be very ugly.
  So is there a better way to solve the problem?</p>