title: Why doesn't this sql query return any results comparing floating point numbers?
body: <p>I have this in a mysql table:</p>
  
  <p><img src="https://i.stack.imgur.com/8wQsx.png" alt="enter image description here"></p>
  
  <p><code>id</code> and <code>bolag_id</code> are <code>int</code>. <code>lat</code> and <code>lngitude</code> are <code>double</code>.</p>
  
  <p>If I use the the <code>lngitude</code> column, no results are returned:</p>
  
  <p><strong><code>lngitude</code> Query:</strong> <code>SELECT * FROM location_forslag WHERE</code>lngitude<code>= 13.8461208</code></p>
  
  <p>However, if I use the <code>lat</code> column, it <em>does</em> return results:</p>
  
  <p><strong><code>lat</code> Query:</strong> <code>SELECT * FROM location_forslag WHERE</code>lat<code>= 58.3902782</code></p>
  
  <p>What is the problem with the <code>lngitude</code> column?</p>