title: Greater Than and Less than MySql query failing with decimal field
body: <p>I have a database which has 3 columns:</p>
  
  <pre><code>user_id | lat      | lon
  1       |-1.403976 | 53.428692
  2       |-1.353276 | 55.224692
  etc etc       
  </code></pre>
  
  <p>Both lat and lon are set as decimal fields. I'm running a query similar to this but it isn't filtering based on being greater than and less than the given lat/lon numbers:</p>
  
  <pre><code>SELECT * FROM `table` WHERE `lat` &lt; '-1.399999' AND 'lat' &gt; '-1.300000' 
  AND 'lon' &lt; '55.555555' AND &gt; '53.000000'
  </code></pre>
  
  <p>This query just returns every row in the table and I don't know why? Is it something to do with the fields being set as decimals?</p>
  
  <p>I hope someone can help - i know its probably a simple answer if you know it.</p>
  
  <p>As per comment - here's the create table:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `members` (
  `user_id` int(10) NOT NULL AUTO_INCREMENT,
  `lat` decimal(8,6) NOT NULL,
  `lon` decimal(8,6) NOT NULL,
  UNIQUE KEY `user_id` (`user_id`),
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=136 ;
  </code></pre>