title: Query to find the different email address series
body: <p>I need some help on the problem below-</p>
  
  <p>I want to find the series of different email addresses from the database table using SQL query.</p>
  
  <p>My database table contains email addresses -</p>
  
  <pre><code>abc1@..com,
  abc2@..com,
  .
  .
  .
  .
  f1@..com,
  f2@..com,
  f3@..com
  .
  .
  .
  xyzpqr1@..com,
  xyzpqr2@..com
  .
  .
  </code></pre>
  
  <p>These email series patterns are always different but they shares the common series pattern like numbers say 1 to 10 e.g. <code>pq1@..com,pq2@..com,pq3@..com,...,pq10@..com,,,</code>
  where text "pq" could be anything which is a random text. And also numbers (1 to 10 in above case) are also random.</p>
  
  <p>We can detect this series by copying the data in excel and then manually checking the each records. But this is not the feasible solution</p>
  
  <p>So I was thinking that can someone come up with the SQL query which would be helpful to detect such series of email addresses.</p>