title: Round to highest .5 value in mysql
body: <p>I am trying to round the value to highest 0.5 value.</p>
  
  <p>For example if i execute</p>
  
  <pre><code> select round(5.456);
  </code></pre>
  
  <p>Then I want to get the result as 5.5 and if I execute</p>
  
  <pre><code>select round(5.73434);
  </code></pre>
  
  <p>Then I want to get the result as 6.</p>
  
  <p>That is if value is between 0 and 0.5 then it must be rounded to 0.5 and if the value is between 0.5 and 1 then it must be rounded to 1.</p>
  
  <p>How can I do this? Thanks in advance</p>