title: MySQL replace numbers after hyphen
body: <p>I have a large table with ZIP codes but they are in long format like : 06608-1405</p>
  
  <p>What I require is to REMOVE the hyphen and the numbers after the hyphen. I have using MYSQL REPLACE before but not sure how if you can use Wildcards.</p>
  
  <p>Cheers for you time.</p>
  
  <p>J</p>