Following query will find records which came under 1.5 km on the basis of user current latitude and longitude
user latitude is 21.153518
user latitude is 79.045513
SELECT *
FROM users
WHERE ( 3959 * ACOS( COS( RADIANS( 21.153518 ) ) * COS( RADIANS( users.latitude ) ) * COS( RADIANS( users.longitude ) - RADIANS( 79.045513 ) ) + SIN( RADIANS( 21.153518) ) * SIN( RADIANS( users.latitude ) ) ) ) < 1.5
Here is some more query...
