title: Laravel 5.5 Eloquent get distinct with more than 1 column
body: <p>I have a table which is indexed by id and also has a column description.</p>
  
  <p>I want to use this in a form with it populating a radio group.</p>
  
  <p>My problem is if I try</p>
  
  <pre><code>$colours = Colours::where('manufacturer_id',"=",$man)-&gt;select('id','description')-&gt;orderBy('description')-&gt;groupBy('description')-&gt;get();
  </code></pre>
  
  <p>I get</p>
  
  <blockquote>
    <p>SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cl24-ids.colours.manufacturer_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: select <code>description</code>, <code>manufacturer_id</code> from <code>colours</code> where <code>manufacturer_id</code> = 1 group by <code>description</code>)</p>
  </blockquote>
  
  <p>Any ideas please or should I just use a non Eloquent solution?</p>