title: mysql compare float numbers ignored
body: <p>I am trying to compare two floating numbers.
  I have already seen a number of questions here on stackoverflow but I didn't find a solution yet.</p>
  
  <pre><code>$sql = "SELECT price FROM list
          WHERE price != '".(float)$price."'";
  </code></pre>
  
  <p>Price is "6.30"
  In DB I want to get all results except the one with price 6.30. But it ignores it completely.</p>
  
  <p>I know it has something to do with floats. I cannot edit DB table, this is not an option unfortunately.</p>
  
  <p>Is there any other way to do this by just using mysql?</p>