title: How to implement equal/approximate condition for double datatype in mysql?
body: <p>I have a table with one column of double datatype. I want to select rows by comparing against double value. If there is not exact value exist in the double column, I want to fetch rows containing double value which are equal or closest/approximate.</p>
  
  <pre><code>select * 
  from tablename 
  where DoubleColumnName equal/approx "some double value"
  </code></pre>