How to truncate decimal points in mysql column
<p>I have table like this </p>

<pre><code>Percentage
0.00
0.00
10.10
0.90
0.00
</code></pre>

<p>I want that to be like this</p>

<pre><code>Percentage
0
0
10.10
0.90
0
</code></pre>

<p>And this is my query</p>

<pre><code>  SELECT discount_percentage - TRUNCATE(discount_percentage, 0),    IF(discount_percentage - TRUNCATE(discount_percentage, 0) = 0.00, TRUNCATE(discount_percentage, 0), discount_percentage) AS percentage FROM `order` WHERE 1
</code></pre>

<p>And my result is:</p>

<pre><code>      discount_percentage - TRUNCATE(discount_percentage, 0)   percentage
                                                       0.00     0.00
                                                       0.00     0.00
                                                       0.99     10.99
                                                       0.00     0.00
</code></pre>

<p>My precentage field have type as float</p>

<p>If 0.00 means i want like 0 also if 10.00 means 10 and 10.99 means 10.99. Please if anyone know get me out of this</p>