title: Mysql grouping / order by
body: <p>Just wondering if this is possible at all. I have a table which has two columns, item and category which when I use the following SQL statement displays:</p>
  <pre><code>SELECT * from tableitems ORDER BY category;
  </code></pre>
  <p>Table:</p>
  <pre><code>item    category
  aitem   AAA
  aaitem  AAA
  abitem  AAA
  
  acitem  BBB
  baitem  BBB
  bcitem  BBB
  
  aditem  CCC
  bditem  CCC
  caitem  CCC
  </code></pre>
  <p>Is there anyway in MySQL to display it like this in a single MySQL statement?</p>
  <pre><code>AAA
  aitem   
  aaitem  
  abitem  
  BBB
  acitem  
  baitem  
  bcitem  
  CCC
  aditem  
  bditem  
  caitem 
  </code></pre>