I have a made a query which as far as I can tell, returns the data that it should. The issue I have is that it is telling me an incorrect distance.

This is the join part of the query:

Code MySQL:
 select business_id, 
       sqrt( ( latitude_miles - 54.6665 )^2
           + ( longitude_mpd * (longitude - 5.66341 ))^2 
       ) as distance 
from address
WHERE 1
ORDER BY distance;

I can't see anything wrong there so, maybe my statement which inserted the values for latitude_miles and longitude_mpd was wrong?

Code MySQL:
UPDATE 
  address
SET
  latitude_miles = 69.1 * latitude,
  longitude_mpd = 69.1 * COS(latitude * 3.14159265 / 180)

any pointers are welcome.

bazz