title: SQL - Finding rows with similar values for a column
body: <pre><code> ID   NAME       Email
   1    John       john@example.com
   2    Mathew     mathew@example.com
   3    John       jon@example.com
   4    Johnson    johns@example.com
   5    Peter      pete@example.com
  </code></pre>
  
  <p>How can I create a query that will return</p>
  
  <pre><code>1    John       john@example.com
  3    John       jon@example.com
  4    Johnson    johns@example.com
  </code></pre>
  
  <p>Ansers like that for <a href="https://stackoverflow.com/questions/1786533/find-rows-that-have-the-same-value-on-a-column-in-mysql">Find rows that have the same value on a column in MySQL</a>  returns rows with same value. Here I need similar values</p>