CODE EXAMPLE FOR SQL

how to get nearest location in mysql with latitude and longitude

SELECT latitude, longitude, address_1, SQRT(
    POW(69.1 * (latitude - [starlat]), 2) +
    POW(69.1 * ([startlng] - longitude) * COS(latitude / 57.3), 2)) AS distance
FROM address HAVING distance < 25 ORDER BY distance

-- where [starlat] and [startlng] is the position where to start measuring the distance.