title: SQL group by query to find only enabled records
body: <p>I have a MySQL table like the following, and I'd like to find the name of the persons which are completely disabled.</p>
  
  <p>This is my table:</p>
  
  <pre><code>+----+----------+---------+
  | id | name     | enabled |
  +----+----------+---------+
  |  1 | person 1 |       1 |
  |  2 | person 1 |       0 |
  |  3 | person 2 |       0 |
  |  4 | person 2 |       0 |
  |  5 | person 3 |       1 |
  |  6 | person 3 |       1 |
  +----+----------+---------+
  </code></pre>
  
  <p>(the <code>enabled</code> column represents a boolean)</p>
  
  <p>In this case, I only want to find person 2, because both records are disabled. I don't want to find person 1, because person 1 is still enabled in row 1, and person 3 is completely enabled, so that on should also be excluded. </p>