title: Manipulating strings - PHP or MySQL
body: <p>I have a table filled with addresses which some have hyphens present in the string.</p>
  
  <p>Some are:</p>
  
  <p><em>"Wheelbarrow rd"</em></p>
  
  <p>others may be</p>
  
  <p><em>"Potato cir - 1 through 100"</em></p>
  
  <p>I'd like to be able to take out everything after the first occurrence of " - " if any at all before outputting the string.</p>
  
  <p>I don't plan on using the hyphenated strings anywhere as of yet - should I manipulate the string in MySQL or PHP. I imagine it'd be better to do in PHP but the upside to doing it in MySQL would be not having to manipulate the string every time I output it. What do you guys suggest?</p>
  
  <p>(I might need the full string later on so I don't necessarily want to do change the records in the DB)</p>
  
  <p>Cheers</p>