title: mysql remove very last character
body: <p>you would think this is answered somewhere but I cant find the exact answer. 
  I need to remove the very last character in a string, it can be any character and the string can be any length.</p>
  
  <p>example 992899d needs to be 992899</p>