title: MySQL Group by one column, but select all data
body: <p>I've got a database which contains lots of data. I would like to select all data, but Group by one column.</p>
  
  <p>So for example:</p>
  
  <pre><code>column a | column b
  example  | apple
  example  | pear
  example  | orange
  example  | strawberry
  </code></pre>
  
  <p>In the example column A is a column which has duplicate values and needs to be grouped.
  Column B however has different values, and I would like to select all these values.</p>
  
  <p>In the end, I would like to get a query that results in:</p>
  
  <pre><code>example
  - apple
  - pear
  - orange
  - strawberry
  </code></pre>
  
  <p>Where the values of column B are in a jQuery accordion.</p>
  
  <p>I've tried and searched for a couple of hours but still haven't found a way to do this.</p>
  
  <p><strong>EDIT:</strong>
  I've manage to solve the problem using the answer Gordon provided. 
  Using PHP I exploded the query results and with a while loop I collected all the data from the arrays.</p>
  
  <p>It's working great now, thanks guys!</p>