title: Compare all rows in a MySQL Table
body: <p>For example I have a row with numbers:</p>
  <pre><code>id   number
  1    5
  2    72
  3    14
  4    72
  5    16
  6    5
  7    14
  8    5    
  </code></pre>
  <p>I would like MySQL to start looking from row 1 and decide if it's row &quot;number&quot; exists (one or more times) or not in the whole table. After that, it should check the second row, etc.</p>
  <p>In this example it should first search for number &quot;5&quot; and it should let me know that there are more than 1 occurrence, than go to the second row and check 72, etc.</p>