title: Get all characters before space in MySQL
body: <p>I would like to get all the characters in a field before a space</p>
  
  <p>For example, if <code>field1</code> is <code>"chara ters"</code></p>
  
  <p>I want it to return <code>"chara"</code></p>
  
  <p>What would this select statement look like?</p>