title: Select a value from MySQL database only in case it exists only once
body: <p>Lets say I have a MySQL table that has the following entries:</p>
  
  <pre><code>1
  2
  3
  2
  5
  6
  7
  6
  6
  8
  </code></pre>
  
  <p>When I do an "SELECT * ..." I get back all the entries. But I want to get back only these entries, that exist only once within the table. Means the rows with the values 2 (exists two times) and 6 (exists three times) have to be dropped completely out of my result.</p>
  
  <p>I found a keyword DISTINCT but as far as I understood it only avoids entries are shown twice, it does not filters them completely.</p>
  
  <p>I think it can be done somehow with COUNT, but all I tried was not really successful. So what is the correct SQL statement here?</p>
  
  <p>Edit: to clarify that, the result I want to get back is</p>
  
  <pre><code>1
  3
  5
  7
  8
  </code></pre>