title: Splitting a value from postcode within sql to group and results
body: <p>I am having some issues with this part of my query, hopefully someone can advise me, Currently i have the postcodes grouping as a complete postalcode but i would like to split this value, and group by the first part of postcode</p>
  
  <p>Perhaps I am overlooking the simple solution to this?</p>
  
  <p>Here is my current query</p>
  
  <pre><code>select *, count(jobline_pickup_add_postalcode) as totals
  FROM rhrj_jobline
  WHERE jobline_date &gt;= '$start' AND jobline_date &lt;= '$end'
  GROUP BY jobline_pickup_add_postalcode
  </code></pre>
  
  <p>Any advice would be awesome</p>
  
  <p>EDIT:</p>
  
  <p>My postcodes look like this</p>
  
  <pre><code>KA12 0RA - 1 
  KA15 1JG - 26 
  KA15 2AT - 1 
  KA15 2LF - 1 
  KA151JG/PA2 6LA - 2 
  </code></pre>