title: MySQL - Combining multiple WHEN conditions in CASE
body: <p>I’m trying to combine 2 rows of results into 1 using the below CASE clause. ‘&lt;26’ should only appear once, and the results should be combined. </p>
  
  <pre><code>SELECT  
      CASE org.size
          WHEN 0 THEN '&lt;26'
          WHEN 1 THEN '&lt;26'
          WHEN 2 THEN '26-50'
          WHEN 3 THEN '51-100'
          WHEN 4 THEN '101-250'
          WHEN 5 THEN '251-500'
          WHEN 6 THEN '501-1000'
          WHEN 7 THEN '1001-5000'
          ELSE '5000+' END
          AS 'Size',
          COUNT(DISTINCT org.id) AS '# of Companies'
  FROM org INNER JOIN usr ON usr.orgid = org.id
      INNER JOIN usr_role ON usr.id = usr_role.usrid
  WHERE org.deleted = 0 AND usr.brnd = 1 AND usr_role.role = 1
  GROUP BY org.size;
  </code></pre>