title: Compare latitude and longitude in a rectangle area (no distance)
body: <p>I have a database with users, defined with a latitude and longitude in a database (mysql) and I extract the infos with a php script.</p>
  
  <p>An app on mobile allow to draw a rectangle, and send me the coordinates of the top left point, and the coordinates of the bottom right point.</p>
  
  <p>How can I compare the latitudes and longitudes to find wich user is in the rectangle? I found many solutions with a circle and distances, but it doesn't fit my needs...</p>
  
  <p>My current query, wrong! :</p>
  
  <pre><code>SELECT * FROM users WHERE latitude BETWEEN ".$latitudeTopLeft." AND ".$latitudeBottomRight." AND longitude BETWEEN ".$longitudeTopLeft." AND ".$longitudeBottomRight.";
  </code></pre>
  
  <p>Does anyone got an idea? Thanks...</p>