title: MySQL floating point comparison issues
body: <p>I ran into an issue by introducing floating point columns in the MySQL database schema that the comparisons on floating point values don't return the correct results always.</p>
  
  <p>1 - 50.12<br>
  2 - 34.57<br>
  3 - 12.75<br>
  4 - ...(rest all less than 12.00)</p>
  
  <pre><code>SELECT COUNT(*) FROM `users` WHERE `points` &gt; "12.75"
  </code></pre>
  
  <p>This returns me "3".</p>
  
  <p>I have read that the comparisons of floating point values in MySQL is a bad idea and decimal type is the better option.</p>
  
  <p>Do I have any hope of moving ahead with the float type and get the comparisons to work correctly?</p>