title: MySQL Group By up to certain string character
body: <p>I am currently working on a project where I have several string that may start with different message but somewhere in the string will contain a :.</p>
  <p>For example the field may include</p>
  <blockquote>
  <p>Unknown username/password attempted to login. User: admin Failed to</p>
  <p>add user account. MySQL Error: certain my sql error Unknown</p>
  <p>username/password attempted to login. User: administrator</p>
  </blockquote>
  <p>Basically I want to group the fields together up to the : sign e.g. Unknown username/password attempted to login. User: would be grouped as 1 entry.</p>
  <p>Thanks for any help you can provide.</p>