title: MySQL Remove Trailing Zero
body: <p>Is there a built-in function in MySQL the removes trailing zeros on the right?</p>
  
  <p>I have samples and i want my output to be like this:</p>
  
  <pre><code> 1.0    ==&gt;   1
   1.50   ==&gt;   1.5
  10.030  ==&gt;  10.03
   0.50   ==&gt;   0.5
   0.0    ==&gt;   0
  </code></pre>