title: Selecting DISTINCT where not null in MySQL
body: <p>I've got a table that has, for example, <code>ID</code> and <code>Name</code>.</p>
  
  <p>There are multiple rows that contain blank names, but there also can be multiple rows with the same name. I'd like to select all <code>ID</code>s, counting each name only once (<code>DISTINCT</code>), but selecting ALL of the blanks.</p>
  
  <p>The following query naturally only selects ONE blank name. <strong>How can I select all the distinct names plus all of the blank names?</strong></p>
  
  <pre><code>SELECT DISTINCT Name, ID
  FROM TestTable
  </code></pre>