title: MySql Disorder Result set using query
body: <p>Good Evening,
  I have a query like this:</p>
  
  <pre><code>SELECT @c:=@c+1 as Count, CurrentISP 
  FROM (
    SELECT 'yahoo.com' as currentISP
      UNION ALL SELECT 'yahoo.com'
      UNION ALL SELECT 'gmail.com'
      UNION ALL SELECT 'gmail.com'
      UNION ALL SELECT 'hotmail.com'
      UNION ALL SELECT 'hotmail.com'
    ) t
  INNER JOIN ( SELECT @c:=0 )  c
  </code></pre>
  
  <p>Which produces a result set as follows:</p>
  
  <pre><code>Count  CurrentISP
  --
  1   yahoo.com
  2   yahoo.com
  3   gmail.com
  4   gmail.com
  5   hotmail.com
  6   hotmail.com
  </code></pre>
  
  <p>What I want to do is give this set an Ordering as follow:</p>
  
  <pre><code>1) yahoo.com
  2) gmail.com
  3) hotmail.com
  4) maybe some ither Email Provider
  5) when All providers are over start over again
  6) yahoo.com etc etc
  </code></pre>
  
  <p>The reason I would like to do this, is because is to avoid spamming a certain provider with emails at the same time... So I can increase my sender score reputation back to 100%.</p>