title: MYSQL trim dynamically
body: <p>I have a column value like "123|34|65|35" in MYSQL database how can I remove the last "|35" from the column value through a select query?</p>
  
  <p>example:
  this is my table values<br/>
  +--------------------+<br/>
   Values             <br/>
  +--------------------+<br/>
   45|56|2|2015|22    <br/>
  +--------------------+<br/>
   28|40|59|205|7     <br/>
  +--------------------+<br/>
   44|38|29|15|257     <br/>
  +--------------------+<br/></p>
  
  <p>I want to a select query that should gives me the below output
  <br/>
  +--------------------+<br/>
   Values             <br/>
  +--------------------+<br/>
   45|56|2|2015        <br/>
  +--------------------+<br/>
   28|40|59|205       <br/> 
  +--------------------+<br/>
   44|38|29|15        <br/> 
  +--------------------+<br/></p>
  
  <p>any ideas ! the last character is a dynamic character. </p>