title: Possible to delete everything after a 'space' in MySQL field?
body: <p>Let's assume I have the following field:</p>
  
  <p>' name sub _blah '</p>
  
  <p>I can get rid of the outside spaces with the TRIM() function but I am actually looking to remove everything after the first space (after the trim).</p>
  
  <p>so:</p>
  
  <p>'name sub _blah' would turn into 'name'</p>
  
  <p>I know this is possible in PHP but I am trying to do on a MySQL only call. Is there a function I do not know about for this?</p>
  
  <p>Thanks!</p>