title: mysql: store latitude and longitude of a lot of POIs, using mysql spatial, and calculating distances
body: <p>I've to create a db of a lot of restaurants in italy (>100000), and I'd like to create a "near me" function. I woud like to create a table containing latitude and longitude of all restaurants, and I've thought to use mysql spatial.</p>
  
  <p>Do you have any idea of how can I create a query to find all restaurants around me (my coordinates will be taken by gps), in a 10km radius?</p>
  
  <p>I'm trying to undestand distances, but googling around I haven't found anything interesting.</p>
  
  <p>Do you think that using mysql spatial is a good idea? could I use float instead? in this case, how can I create a query to find all restaurants around me in a 10km radius?</p>
  
  <p>Thanks a lot</p>