Select coordinates which fall within a radius of a central point?

I have a database of coordinates in the schema:

ID:Latitude:Longitude:name:desc

I’ve set up my google maps application to show the markers effectively on the screen. However I need to add another feature whereby the user can view all pointers that fall within the radius from a central point.

How would I write up a sql statement of the kind:

Select all pointers that fall within a 10 mile radius of X & Y

EFER

on May 20, 2015.
Add Comment
3 Answer(s)

test

Answered on May 25, 2015.

Hi

on June 1, 2015.
Add Comment

lol 

Answered on July 2, 2015.
Add Comment

blalalalalala

Answered on July 2, 2015.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.